To only get all text after a comma
 

I need a function to obtain just the first name from a cell but the cell has
the name written as:
Smith, Jack
I tried the the MID function but it requires a number to be entered to
dictate where it will start gathering the info. from. I will never know how
long their surname is so I would like something that will find the comma.
Then collect the first name Jack for example from the comma.
Can anyone help please.
Sue

To only get all text after a comma
 

If the text is in A1, then in B1 put =mid(a1,find(",",a1)+2,99)

where 99 is a value to make sure the longest first name is covered

This looks in a1, starting at a position 2 after the comma, ie it
assumes that the format always in cludese a blank space after the
comma

Regards
Mike


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

To only get all text after a comma
 

Hi Mikeopolo,
Thanks, that works just great. Really appreciate it.
Regards Sue

"Mikeopolo" wrote:


If the text is in A1, then in B1 put =mid(a1,find(",",a1)+2,99)

where 99 is a value to make sure the longest first name is covered

This looks in a1, starting at a position 2 after the comma, ie it
assumes that the format always in cludese a blank space after the
comma

Regards
Mike


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