Thread
:
CONCATENATE error?
View Single Post
#
1
Posted to microsoft.public.excel.misc
Martin ©¿©¬ @nohere.net
external usenet poster
Posts: 80
CONCATENATE error?
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
©¿©¬
Reply With Quote
Martin ©¿©¬ @nohere.net
View Public Profile
Find all posts by Martin ©¿©¬ @nohere.net