Concatinate Formatting

P

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."
 
T

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
 
D

Dave Peterson

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

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

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
 
R

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."
Click to expand...

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

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

--ron
 
Top