Concatinate Formatting

[PFLY]

How do Concatinte: Cell A1: Better Cell A2: 1,545 and Cell A3: Test -
to display as "Better1,545Test"? Everytime i try this it loses the comma and
shows as "Better1545Test."

 

[Tyro]

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

 

[Dave Peterson]

=a1&text(a2,"#,##0")&a3

Same kind of things for dates, currency--anything that needs to be formatted.

 

[Tyro]

Correction:

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(A2,"#,#")&A3 to have Better1,545Test
If you want spaces =A1&TEXT(A2," #,# ")&A3 to have Better 1,545 Test

 

[Ron Rosenfeld]

How do Concatinte: Cell A1: Better Cell A2: 1,545 and Cell A3: Test -
to display as "Better1,545Test"? Everytime i try this it loses the comma and
shows as "Better1545Test."

=CONCATENATE(A1,TEXT(A2,"#,###"),A3)

or =A1&text(a2,"#,###")&a3

--ron