text trim combine

  • Thread starter Thread starter Ian Bartlett
  • Start date Start date
I

Ian Bartlett

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
 
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
 
One more:

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

***********
Regards,
Ron
 
Back
Top