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
|