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