R
rocket0612
If I have a cell A1 with a name entered in the format 'Mr A B SURNAME',
how can I get it shortened to just the start and end in B1 so it will
just show 'Mr SURNAME'.
thanks
how can I get it shortened to just the start and end in B1 so it will
just show 'Mr SURNAME'.
thanks