Splitting info in one column

[AB]

Sorry lost my formula. Have List of names, format in one column is "Surname
First name"
Want to split them into 2 separate columns, shall I use LEFT and what extra
info, can't stipulate a number as it varies with length of name, its
something to do with the space between?? but can't remember how to put that
in formula.

Many thanks
Althea

 

[Peo Sjoblom]

Just select the column, do data>text to column and select space as
delimiter,
then click finish

 

[DDM]

Althea, the easiest way to do it is to use the Text to Columns command on
the Data menu. Check it out; it's very intuitive. (You'll need to insert one
"helper" column to the right of your data. Your data is delimited, with a
space as a separator.)

Now if you really insist on using formulas, you have to insert two "helper"
columns to the right of your data.

In the first column, your formula is =LEFT(A1,FIND(" ",A1)-1) and copy down.
In the second "helper" column your formula is =MID(A1,FIND(" ",A1)+1,255)
and copy down.

Select all your formula cells and Edit > Copy > Edit > Paste Special >
Values > OK. Then delete the original data.

 

[AB]

Hi Just tried that, doen't make another column, even tried having a spare
one either side and tried to name them for detination.
Any ideas what I'm doing wrong
Bye
althea

 

[AB]

Thanks all, finally got it
Bye
Althea