Splitting info in one column

  • Thread starter Thread starter AB
  • Start date Start date
A

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
 
Just select the column, do data>text to column and select space as
delimiter,
then click finish
 
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.
 
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
 
Back
Top