Hi, I have data that holds Surname in Column A and First_Name in Column B,
and I would like to return initials in Column C - so 'Betty Anne' becomes 'B
A' etc.
As you can see from some sample data below, not all entries have more than
one name, some have names & initials - I just need to be able to do a
mailshot to 'B A Neill' etc.
Thanks for any help,
Charlotte

SURNAME FIRST_NAME
NEILL BETTY ANNE
MOLLAN PATRICIA A F
QUIGLEY MARLYN
MAYES ELIZABETH ANNIE ELEANOR