CONCATENATE

[How to get commas in the #'s of concaten]

I have the following cells
A1: D Roberts
B1: 56
C1: MAT
D1: 16,608.80

I need the sentance to read:
D Roberts 56 days $16,608.80 MAT

My formula is =CONCATENATE('Delinquent Loan > 30 days'!A3," ",'Delinquent
Loan > 30 days'!B3," days ","$",'Delinquent Loan > 30 days'!D3, "
",'Delinquent Loan > 30 days'!C3)

I am getting:
D Roberts 56 days $16608.8 MAT

How do I get my numbers to have the commas in them?

 

[Elkar]

Use the TEXT function. Try this:

=CONCATENATE('Delinquent Loan > 30 days'!A3," ",'Delinquent

Loan > 30 days'!B3," days ",TEXT('Delinquent Loan > 30 days'!D3,"$#,##0.00"), "
",'Delinquent Loan > 30 days'!C3)

HTH,
Elkar

 

[Ashish Mathur]

Hi,

As suggested, please us the TEXT() function. Also, you can use he & instead
of CONCATENATE() I.e. use str1&str2 etc.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"How to get commas in the #'s of concaten" <How to get commas in the #'s of
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Shane Devenshire]

Hi,

I think it is easier to use the concatenation operator:

='Delinquent Loan > 30 days'!A3&" "&'Delinquent Loan > 30 days'!B3&" days
"&TEXT('Delinquent Loan > 30 days'!D3,"$#,##0.00")& " "&'Delinquent Loan > 30
days'!C3

And it make the formula shorter.

 

[Teethless mama]

Try this:

=CONCATENATE(A1," ",B1," days ",DOLLAR(D1)," ",C1)