text trim combine

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
 
R

Rowan Drummond

One way with no error checking:
=LEFT(A1,SEARCH(" ",A1)+1)

Hope this helps
Rowan
 
R

Ron Coderre

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
 
R

Ron Coderre

One more:

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

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