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.

 

[smartin]

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.

I suspect your cells are formatted in some way that makes them appear to
contain data that is not really there. Applying a format to a cell does
not change its contents, only its appearance. Moreover, formulas such as
concatenate (&) ignore formatting.

Check the cell formatting in A1 and B1 and let us know what you find there.

 

[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)