Search results

Dear Solvers, I have a huge amount of data in an Excel sheet , Where almost all the cells have insert comments Problem encountered is that , Some of Insert comments are showing only the arrow mark not the inside comment , When i right clicked and showed comment it is showing somewhere else...

Thanks Hui, Regards Senthil

Dear Experts, Here i need the solution In an excel sheet 1 cell A1 with text "Senthil" and insert comment with "Quality Department" When i call the cell in sheet2 D5 cell (=sheet1!A1) i got the answer Senthil but not the comment Is there any method or technique to get the comment also

Hi JBA, Can u please elaborate on your problem

Hi Hui, Great !! It Working 100 % fine. Thanks Good Learning as well for me

Dear Solvers, I have a sheet which needs to be printed,I Have inserted two button for printing say Button -1 : A4 size print Button -2 : A3 Size Print Need to Write a macro for, If user chooses A4 print, Page has to align (fit) for A4 landscape and printed and if user chooses A3 Print...

Hi Luke, Congrats!!

Hi Shina, Try this formula =MID(E11,(FIND(".",E11,FIND(".",E11,FIND(".",E11,FIND(".",E11)+1)+1)+1)+1),255) E11 cell contains ur data ie., IND.A.4.08.0225 It will find 4 th dot always, and displays the next characters upto 255 characters Hope this helps !!

Hi Fitz Sorry Application.DisplayAlerts = False Add it in Top of Program -- > below Sub Caution : It will disable all ur alerts

Hi Add This line in Macro Program of that XL Application.displayalerts = true

Thanks Hui,

Hi Faseeh, From left !!

Hi Solvers, I Have file name as D:DataPersonalsramasamdesktopExceldata.xls Want to find the 4th Slash() what is simple way Find Function looks big !! Thanks

Hi It depends upon the error, Better U Post it with screen shot of those

Hi Go to data --> Validation ->> Select Custom from Allow list and type this formula = ISNUMBER(H3) Cell accepts only numbers not text

Thanks Ashwin, Hui

Hi Just for Learning !!

Hi Pradip, Welcome to chandoo.org For ur query, i dont think it is possible as usually in Y axis it takes on multiples rather than the value (in scatter graph)

Hi Sa Try this =(TODAY()-H17)/365 H17 = Select your cell which has your date

Hi Please look this link, If any query let me know http://www.microsoft.com/learning/en/us/certification/mos.aspx

Hi Jthami, Select all the cells which has 'and you will find auto fill option, click convert to number If u dont understand please post

Hi Use this =TRIM(LEFT(H24,7)) Thanks Senthilkumar_rm

Hello Jtha, You should click the top Download : Example Index.xls 46Kb , Which is near Speedy share logo Thanks Senthilkumar_rm

Hello, Why to use a formula, Select the range of cells where you want to enter number as text and right click | Format cells |(Short cut Ctrl +1)| Number tab | Category -> Select Text Now, You can enter any number it gives u text format Senthilkumar_rm

Thanks a lot