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