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

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

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