View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rowan Drummond
 
Posts: n/a
Default 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