Re: I want first name only

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try this formula and pull down.

=RIGHT(A1,LEN(A1)-FIND(",",A1)-1)

Or select the list of names and Data > Text to column > Delimited > Next >
check both space and other > enter a coma > Finish.

HTH
Regards,
Howard

"Barrett9699" <Barrett9699.2cuwq6_1156107609.2729@xxxxxxxxxxxxxxxxxxxxx>
wrote in message
news:Barrett9699.2cuwq6_1156107609.2729@xxxxxxxxxxxxxxxxxxxxxxxx

I have a list of names in the format 'Last, First'

I want a funtion that will return the first name only. Basically, I
want to trim off everything before the comma as well as the space after
the comma.

I don't think the RIGHT() function will work because these names are
different lenghts, as you can imagine.

Can you help?


--
Barrett9699
------------------------------------------------------------------------
Barrett9699's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=37573
View this thread: http://www.excelforum.com/showthread.php?threadid=573581



.

Relevant Pages

  • Re: Formula
    ... Assuming that string is in A2 and the name is always followed by a ... comma, this formula will pull out the name: ... JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73 ...
    (microsoft.public.excel.programming)
  • Pulling data from one cell to another
    ... A column contains people's first name and last seperated by a comma. ... can I tell excel to pull everything after the comma to B column and ...
    (microsoft.public.excel.misc)
  • Re: Multiple parameters
    ... coma) as delimiter: ... > place a comma between the ... > table by a list of IDs sounds like a mess to me! ... I need to retrieve peolple's addresses from a table. ...
    (microsoft.public.access.queries)
  • Controversial medical cases
    ... Does anyone remember a medical case a while ago where a wife was in a coma ... and I think the husband wanted to pull her off life support and grant his ...
    (sci.med.transcription)
  • Re: Sickening Nunnxclusivity
    ... God knows how your babies survived, Vicky. ... You didn't really need that comma. ... Or that coma. ...
    (uk.sport.football)