Initials from a name

[trunyon]

Can you show me a formula to change a name to initials?
Example John Doe = JD

[BigBas]

Assuming the name is in cell A1, and the first and last name are separated by a space, this formula will work:

=LEFT(A1,1)&" "&LEFT(REPLACE(A1,1,FIND(" ",A1),""),1)

[Paul Edwards]

Works fine, but can an error filter put incorporated so if only one word is entered, it just shows one initial (instead of an error)?

[daddylonglegs]

Perhaps try

=LEFT(REPLACE(A1,2,FIND(" ",A1&" ")-1,""),2)

[Paul Edwards]

Perhaps try

=LEFT(REPLACE(A1,2,FIND(" ",A1&" ")-1,""),2)

Works Great! Thanks heaps, DLL.