Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONCATENATE | Excel Discussion (Misc queries) | |||
Concatenate | Excel Worksheet Functions | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
concatenate | Excel Worksheet Functions | |||
Un - Concatenate? | Excel Worksheet Functions |