Text to Columns like Fomula (Excel 97)

Topic

New Reply

Hi There,

Is there a formula that will get me everything to the right of a space. I want to do this in a fomula, not using Text To Columns…

Thanks!

Reply | Quote

Replies

Found it!
Didn’t search hard enough on the web before I posted

=MID(A2,FIND(” “,A2,1)+1,LEN(A2))

Reply | Quote

If the text is in A1, then this should do it:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

Reply | Quote