One mo

A1: Last First
B1: =SUBSTITUTE(LEFT(A1,FIND(" ",A1)+1)," ","")
also returns LastF

***********
Regards,
Ron


"Ron Coderre" wrote:

For A1: Last First

Options:
B1: =LEFT(A1,FIND(" ",A1)-1)&MID(A1,FIND(" ",A1)+1,1)
Returns LastF

B1: =LEFT(A1,FIND(" ",A1))&MID(A1,FIND(" ",A1)+1,1)
Returns Last F

B1: =LOWER(LEFT(A1,FIND(" ",A1))&MID(A1,FIND(" ",A1)+1,1))
Returns lastf

Does any of that help?

***********
Regards,
Ron


"Ian Bartlett" wrote:

In one cell I have a name laid out simply as
Lastname Firstname (1 space between)
what I require in another cell is a combination of lastname
and first letter of firstname.

Thanks in advance

Bart