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:


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

Thanks for your help


--
mikeyVo
------------------------------------------------------------------------
mikeyVo's Profile: http://www.excelforum.com/member.php...o&userid=34277
View this thread: http://www.excelforum.com/showthread...hreadid=563320