Quickie !! Split text in a cell

[Soapydux]

Hi I am trying to split a name into firstname & surname, but cant seem
to do it.

I have in say Cell A1 John_Smith

and I want to automatically have

Cell B1 John
Cell C1 Smith

Thanks

 

[Dave Peterson]

Select the column
data|text to columns
delimited by a space (or other (underscore???))

 

[Guest]

Dave's is the easiest method, but if you need a formula use these

=LEFT(A1,FIND("_",A1)-1)
=RIGHT(A1,LEN(A1)-FIND("_",A1))

 

[Soapydux]

Yep that works. Thanks ;0)