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