Separate date and text

**dimi1963** · 09-30-2011, 07:25 AM

Hi I am trying to separate text and date from one cell. The cell loos like this:
9/22/2011 3:45 PM Notarangelo, Robert
I need to get the name out of it and populate another cell with it. The problem here is that is not the same name, and the lenght of the text is different and the RIGHT, LEFT, MID functions do not work. Your help, as always, is highly appreciated.

**arlu1201** · 09-30-2011, 07:29 AM

Use the text to columns feature by using the fixed width delimiter.

**dimi1963** · 09-30-2011, 08:43 AM

Text to columns is not a good sloution for me as I have columns adjacent to the column in question that cannot be moved. Some kind of a formula would be ideal for my purpose. Thank you anyway for the reply.

**daddylonglegs** · 09-30-2011, 08:48 AM

Assuming the time always ends with AM or PM then you can just take everthing after the "M", e.g. with data in A2 try this formula

=TRIM(REPLACE(A2,1,FIND("M",A2),""))

**dimi1963** · 09-30-2011, 10:50 AM

Originally Posted by daddylonglegs

Assuming the time always ends with AM or PM then you can just take everthing after the "M", e.g. with data in A2 try this formula

=TRIM(REPLACE(A2,1,FIND("M",A2),""))

Didn't work.