Concatenate formula or &
Sam
Your choice of two methods.
1. Get rid of F1 and use this formula =A1&B1&C1&D1&TEXT(E1,"#,##0.00%")
2. Change E1 to =(A1/C1)*100 then =A1&B1&C1&D1&TEXT(E1,"#,##0.00")&F1
Gord Dibben MS Excel MVP
On Thu, 18 Jan 2007 08:39:36 -0800, Sam wrote:
I am creating a text template in excel and I have the following 2
rows(combination of text, number and formula and %). please note that I
changed the format of E1 to percentage with 2 decimal.
To combine the following cells together:
A1 | B1 | C1| D1 | E1 | F1
2 | Divided by | 3 | is | =(A1/C1) | percent
i created this formula in cell A2:
=A1&B1&C1&D1&E1&F1
and i get:
2 Divided by 3 is: .666666666666 percent
and i want to get the following in one cell:
2 Divided by 3 is: 66.66% percent
what should i do?
|