CONCATENATE
 

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?

CONCATENATE
 

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


"How to get commas in the #'s of concaten" wrote:

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?

CONCATENATE
 

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

CONCATENATE
 

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"How to get commas in the #'s of concaten" wrote:

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?

CONCATENATE
 

Try this:

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


"How to get commas in the #'s of concaten" wrote:

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?