Thread: CONCATENATE
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
 
Posts: 964
Default 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?