separating names

M

mikeyVo

I have a spreadsheet of thousands of names. The names are typed in on
cell: last name, first name. Does anyone know how to split the name
into two different cells?

Thanks for your hel
 
M

Marcelo

Hi Mikey

if the names are separete by a ","

use for the last name =left(a2,search(",",a2,1)-1)
for the first name =right(a2,search(",",a2,1)-3)

hth
regards from Brazil
Marcelo

"mikeyVo" escreveu:
 
D

Duke Carey

Select the column with all the names and use Data>Text to columns. Indicate
that the text is delimited and click on Next. If the names are separated
with a space or a comma, check the appropriate box and click on OK.
 
Top