How to separate 2 words into separate kolumns

[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.

 

[NC]

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

 

[NC]

you can also use

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

regards
NC