Concatenate with hyphens

[Eric]

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.

 

[Dave Peterson]

Select A1
What do you see in the formula bar?

Select B1
What do you see in the formula bar?

I'm guessing that the string you see in the cell is a custom format.

 

[Ashish Mathur]

Hi,

Works fine for me - cannot replicate your problem.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Shane Devenshire]

If A1 contains 451234 and is formatted as ##-#### and
B1 contains abcd and is formatted as "67-"@

you will get 451234 abcd in the concatenated cell.

 

[Taffy]

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