I have got most of this formula working ok but I cant work out how to do the length.
I have a name that I am trying to split (I am wanting the first name)
Currently I have =MID(A2, SEARCH(", Dr ",A2,1)+5, 15) but That is 15 characters. What I would like is to take it to the next SPACE after.
IE
Smith, Dr John Peter Andrew would return just John and
Jones, Dr Elizabeth Mary Louise would return Elizabeth
Can anyone help me finish off the formula please.
Bookmarks