Thread: take first name out of column & put it in another column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mikeopolo
 
Posts: n/a
Default take first name out of column & put it in another column

One way:

If A1 contains

Dagg Fred

Then in B1 type =LEFT(A1,FIND(" ",A1)-1)

This assumes that there is only one first name and one surname, and
there is a single space between them

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=519818

Reply With QuoteReply With Quote