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

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


Soapydux wrote:

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

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" wrote:

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

Yep that works. Thanks ;0)