View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default 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."