Thread: rename
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Martin ©¿©¬ @nohere.net Martin ©¿©¬ @nohere.net is offline
external usenet poster
 
Posts: 80
Default rename

On Tue, 23 Mar 2010 10:02:06 -0700, Russell Dawson
wrote:

=CONCATENATE(D2,C2)


Hi Russell, this works fine
however, a space is needed in the formula

CarrickMr & Mrs F. - should be Carrick Mr & Mrs F.
How would I fix that please ?
--
Martin
©¿©¬