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