G GN0001 Member Nov 17, 2011 #1 I have a string like this: Mar 1 1962 12:00PM I need to pull out the date. Can anybody please help with this? Thank you in advance, Guity
I have a string like this: Mar 1 1962 12:00PM I need to pull out the date. Can anybody please help with this? Thank you in advance, Guity
N NARAYANK991 Excel Ninja Nov 17, 2011 #2 Hi , Use the following : =DATEVALUE(REPLACE(LEFT("Mar 1 1962 12:00PM",10),6,1," , ")) Narayan
G GN0001 Member Nov 18, 2011 #3 Thank you very much, it worked, is there any shorter way? I have many rows that each one has a different date format, Do you think what I should I do to make all the dates to be consistent? Sorting? Any idea? Guity
Thank you very much, it worked, is there any shorter way? I have many rows that each one has a different date format, Do you think what I should I do to make all the dates to be consistent? Sorting? Any idea? Guity
N NARAYANK991 Excel Ninja Nov 18, 2011 #4 Hi , Can you copy + paste a few items of data , so that I can get an idea of the kind of variation ? Narayan
Hi , Can you copy + paste a few items of data , so that I can get an idea of the kind of variation ? Narayan
