Concatenate with hyphens

  • Thread starter Thread starter Eric
  • Start date Start date
E

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.
 
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.
 
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.
 
Back
Top