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, Please find the attached file and help me how to extract data. Thanks in advance 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, 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...

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, 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...

Hello Sir, I want to highlight the values which are repeated continuously. Please find the link for the excel file and do the needful. http://www.2shared.com/file/jsdbaiZ_/Book1.html

Hello Sirs, Need a Macro which saves the workbook/file automatically at every 10 minutes.

Hello Excel Gurus, In our organization I found an excel file with a macro which really useful for me, but I want to make few changes in it as the VB code is protected with a password. Is it possible to know/break that password? If yes, Please give me a solution. Reason being asking this is...

Hello Sirs, I need a VB macro to change the text from lower case to upper case automatically. Eg : If I enter "t" in cell "C5" it should get change to "T". I need to a particular range like "C$2:C$100". Regards, Manoj

Hello, I have created a macro which is working perfectly, but when I am opening a new excel file unable to run the macro. Please advise me who to save that macro which should be run in any excel file even the file which has macro is closed.

Hi Excel Gurus, I have created a macro for DATA Validation, in the code below there is range (Formula1:="=$F$2:$F$4"), instead of the range, I want to declare the list there itself like ("123","abcd","pokeman", etc). Request you please help me in this regard. F2=123 F3=abcd F4=pokeman...

Hello Sir, I have a master file.xlsx consisting 1000 rows and 10 columns (need to enter data from colmn 6 to column 10) of data, from which i allocated 100 rows of data to 10 employees in 10 different .xlsx files. After making entry from column 6 to column 10, I want to copy the entried data...

Sir, Request you to give ur mail id. I need to prepare a timesheet which automatically captures the START & END time after processing a loan, we process about 250 to 300 loans on a daily basis. Is it possible to create the timesheets. A sheet consists fields like LOAN NO, BORROWER FNAME...

Hi Sir, Can u pls tell me that how to paste the value by using VBA in excel. Eg: In the cell A5 there is a formula "=Sum(A2:A4), I want to copy and paste the answer in the format of VALUE in cell A6 by VBA code in a worksheet/workbook. Request you to help in this regard.

How to get a Msgbox() automatically(without shortcut / command button) when a value gets changed in a particular cell. eg: If the value in the Cell A3 is >= 100, A message box should appear.