Thread: CONCATENATE
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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?