Thread: combine titles/names - how?
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Martin ©¿©¬ @nohere.net Martin ©¿©¬ @nohere.net is offline
external usenet poster
  
Posts: 80
Default combine titles/names - Again
On Mon, 22 Mar 2010 05:25:01 -0700, Mike H
wrote:

try this

=LEFT(TRIM(C1),LEN(TRIM(C1))-0)&" "&D1

Thank you Mike
That did the trick
--
Martin
©¿©¬
Reply With QuoteReply With Quote