Get Initials out of Full Name

[Accusoft]

Hi!

I have A1= Lisa Maria,

1. i need a result in B1= L M (i.e. L of Lisa and M of Maria in caps and a single space in between)

and

2. also need result in C1= L M (i.e. L of Lisa and M of Maria in caps and 5 spaces in between)

appreciate your early response

[FDibbins]

Hi and welcome to the forum

If you only have the 2 names, use this...
=UPPER(LEFT(A1,1))&" "&UPPER(MID(A1,FIND(" ",A1,1)+1,1))