Concatinate Formatting
 

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

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

Concatinate Formatting
 

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

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

PFLY wrote:

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

--

Dave Peterson

Concatinate Formatting
 

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


"Tyro" wrote in message
...
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."

Concatinate Formatting
 

On Tue, 25 Mar 2008 14:20:01 -0700, PFLY
wrote:

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