Search results

Hi, Please help me with the formula in extracting first 2 words in one cell. I searched the forum before posting this, could not found the results for my requirement. Uploading sample file. Thanks in advance.

Hello Everyone, Need formula in E4 & E5 cells. Please find the attached excel file. Thanks in advance. Manoj

Parveen Kaur Munish Abrol Sandeep Chauhan Varun Sachdeva Jyoti Jhon Anjali Singh

Hi All, Thanks those who raised questions and the solutions given with crystal clear explanation by Excel Gurus. Special thanks to Narayank991. This site www.chandoo.org is awesome.

Hi, May be simple but lengthy process, any how thanks for sharing the solution.

Hi Bosco, Thanks for the explanation.

Thank you all for making my job easy.

Very Thanks

Hi, Please find the attached file and help me how to extract data. Thanks in advance Manoj

Hi, Can you upload a text file as I cann't open .rar file due to security reasons in the office. Manoj

Hi, Is there any short cut to FILL LEFT cell same as RIGHT (Ctrl+R). Thanks in advance Manoj

Hi, Can any one tell me how to add a profile picture for ms-office 2013 (Excel, Word, Outlook etc). I didn't found any option in account settings. Thanks in advance.

Hi, Narayan Sir created a macro in the year 2012 (to copy data into main file from many other excel files - consolidation). The macro was running perfectly in 2005 and 2007 version, but excel is upgraded to 2013 version as per organisation's policy. Now I am getting error while running the...

Hi Chandram, Do you mean Turn around Time (TAT) ????

Thanks Deepak, Even I need this....... will try for sure.....

Thanks

Thanks for the reply. I want it without using CTRL+H.

Hi, When I copy, paste the names from one file to another, I want the name "John" should replace with "John Vijay" with out using CTRL+H, as the data is large. I searched in the forum and didn't found the same before posting this. Please help. Thanks in advance

As per the below, I didn't found DRAW menu in bottom left corner. Can any one please help me how to change the shape of the comment box. "Just select the cell comment, go to draw menu in bottom left corner of the screen, and choose change auto shape option, select a 32 pointed star or heart...

thanks, but I need the file to open as the size of calculator

Hello Sir, I need a file to be opened in a minimized window. Is that require VBA? If yes, Can any one please provide the code. Thanks in advance. Manoj

Hello Sir, When using the above formula for the following dates: 01/01/2016 and 12/31/2045, the result is "29", where as it should return "30" which is correct "=DATEDIF(H9,H10,"Y")" (H9 and H10 are cell address). But if I use "=DATEDIF(H9,H10,"M")" and the result divided by 12, getting "30"...

Hi, Thanks for the reply, but i am looking is there any other solution without changing the system settings. Thanks Manoj

Hi, Is there any method to change the color of the comments indicator, default color is RED. Regards, Manoj

Hi Excel Ninjas, Pls suggest me a suitable chart - Turn around time(TAT) for all work types is 30 days - Type A,B,C - completed on 1st May, Type D - compltd in 3 days from 2nd May to 4th May, Type E - cmpltd in 1 day - 7th May, Type F,G - compltd in 2 days - 8th-9th May, Type H - cmpltd in 9...