HOW DO I.................

  • Thread starter Thread starter Rory
  • Start date Start date
R

Rory

I have imported data from a database to a spreed sheet. I
have a names colum in which I have peoples first & surname
seperated with a SPACE in a single cell.
eg
Cell 1
Andrew freeman.

how can I move the surname to another cell without
manually cutting and pasting??
eg

cell 1 | cell 2
Andrew Freeman
 
Use the text functions left and find, in the following way:

=LEFT(A1, FIND(" ", A1)-1)... you'll get the first word
(whatever is before the first space)

=RIGHT(A1, LEN(A1)-FIND(" ",A1))... you'll get whatever is
after the first space
 
If you could put your frist name in cell 2 and the last name in cell
you could put these formulas in each cell respectively

you name is in cell A1 (andrew freeman)

cell B1---- =Left(A1,Find(" ",A1,1)-1)

cell C1 ---- =Right(A1,Len(A1)-Find(" ",A1))

I'm kind of new to excel so I haven't figured out how to make the firs
name to be in cell A1 without a circular reference error.

Maybe you could hide column A so no one could see it or create a macr
to delete the names in column A.

Thought this might help you
 
Back
Top