Quickie !! Split text in a cell
 

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

Quickie !! Split text in a cell
 

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

Quickie !! Split text in a cell
 

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

Quickie !! Split text in a cell
 

Yep that works. Thanks ;0)