To only get all text after a comma

S

Sue

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
 
M

Mikeopolo

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 i
assumes that the format always in cludese a blank space after th
comma

Regards
Mik
 
Top