I need to remove titles (Mr/Mrs/Miss) preceeding the names in one cell and copy them to another cell. Any idea? Your advice is much appreciated.
=MID(C2,SEARCH(" ",C2)+1,LEN(C2)-SEARCH(" ",C2)+1)
This will work whatever be the tile in C2 Mr,Mrs or Miss etc. The logic is find the first blank(that is after the title) and use that position in the mid function.
Type in C2
Mr john smith or Miss Gabriel smith
and see what happen in the formula cell
Suppose Mr john smith is in sheet 1 cell C2
Then in any other sheet and in any empty copy this formula
=MID(Sheet1!C2,SEARCH(" ",Sheet1!C2)+1,LEN(Sheet1!C2)-SEARCH(" ",Sheet1!C2)+1)
Experiment with this formula
Thanks to venkat1926 for this tip on this forum.