text trim combine
 

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

text trim combine
 

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

Hope this helps
Rowan

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

text trim combine
 

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

text trim combine
 

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

text trim combine
 

Thanks very much Rowan and Ron

"Ian Bartlett" wrote in message
news:QoJnf.107102$Gd6.11761@pd7tw3no...
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