View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
SueW SueW is offline
external usenet poster
 
Posts: 14
Default CONCATENATE error?

=CONCATENATE(C2,D2)

"Martin ©¿©¬ @nohere.net" wrote:

Hi
in column C row 2 I have Mr & Mrs E.
in colum D row 2 I have McAllister
When I put the formula =CONCATENATE(D2,C2) in E2 I get
McAllisterMr & Mrs E.

How do I adjust the formula to get
McAllister Mr & Mrs E. ?
--
Martin
©¿©¬

.