and this formula works for 3 names or initials, guess you will not
need mo
=TRIM(LEFT(B2;1)&" "&IF(ISERROR(MID(B2;FIND("
";B2;1)+1;1));"";MID(B2;FIND(" ";B2;1)+1;1))&"
"&IF(ISERROR((MID(B2;LEN(FIND(" ";B2;1)+1)-1;1)));"";MID(B2;LEN(FIND("
";B2;1)+1)-1;1))&" "&A2)
Maybe you will need to change all coma-points to comas depending on
your regional settings.
regards
--
Mladen
http://excelancije.bloger.hr
On Mar 21, 4:41 pm, Mike wrote:
This works for 2 initials if they are seperated by a space or 2 names which i
guess wiould always be seperated bay a space. With the 2 forenames or
initials in B1 try
=UPPER(LEFT(B1,1)&" "&MID(B1,FIND(" ",B1&" ")+1,1))
Mike
"Charlotte Howard" wrote:
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- Hide quoted text -
- Show quoted text -