Your formula should read as follows
=CONCATENATE(A1," ","&"," ",B1)

--
Taffy ~ Pulled in EVERY Direction & as SWEET as can be!!


"Eric" wrote:

I'm trying to concatenate the text strings from two cells. Both strings
include text and numbers separeated by hyphens. Cell A1 = ##-#### Cel B1 =
##-@@@@.
When I try to merge the two using =A1&" "&"B1 I get @@@@, the text string
after the hyphen in the second cell. Why is it cutting off at the hyphen and
what can I do to remedy this?

Many thanks in advance for your assistance.