Concatinate Formatting
That is because cell A2 has the value 1545 and is formatted to display as
1,545. There is no comma in the cell value
Try =A1&TEXT(B1,"#,#")&C1 to have Better1,545Test
If you want spaces =A1&TEXT(B1," #,# ")&C1 to have Better 1,545 Test
Tyro
"PFLY" wrote in message
...
How do Concatinte: Cell A1: Better Cell A2: 1,545 and Cell A3:
-
to display as "Better1,545Test"? Everytime i try this it loses the comma
and
shows as "Better1545Test."
|