How to separate 2 words into separate kolumns

  • Thread starter Thread starter Piotr
  • Start date Start date
P

Piotr

Hi
I have just exported my address book in to Excel file,
what I need to do is make from one field where I have:
John Brown
separate John in to column Name and remove Brown in to column surrname.

I cant find any idea how to do such a thing.
 
you can use following formulas

consider a1 here as cell with complete name

for first name formula =left(A1,find(" ",a1))
for surname =right(A1,len(a1)-find(" ",a1))

Regards
NC
 
you can also use

menu data\text to columns feature of excel choose delimited in first
window & space as separator

regards
NC
 
Back
Top