K
kwrohde
can u put a formula and text in the same cel
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
H
hcj
Yes - through concatenation.
=string&TEXT(value,format) or =TEXT(value,format)&
string, or any combination
string and value can be cell references. You might want
stick a &" "& in the middle for separation.
Hope this helps.
=string&TEXT(value,format) or =TEXT(value,format)&
string, or any combination
string and value can be cell references. You might want
stick a &" "& in the middle for separation.
Hope this helps.
K
kwrohde
im not quite following this can u put it in terms a 3 year old ma
understan
understan
G
Gord Dibben
Entered in A1
="This is the total of these two cells " & A2 + A3
Where A2 and A3 contain numbers.
Your data and addresses may differ, but the basics are the same.
Gord Dibben Excel MVP
="This is the total of these two cells " & A2 + A3
Where A2 and A3 contain numbers.
Your data and addresses may differ, but the basics are the same.
Gord Dibben Excel MVP
K
kwrohde
ok that worked, but I cant seem to do anything with the # in that cell.
I cant say use the # inside the cell with text & #s in a formula i
another cell. It gives me #VALUE!. any idea
I cant say use the # inside the cell with text & #s in a formula i
another cell. It gives me #VALUE!. any idea
G
Gord Dibben
Right. The data is now text.
You can use a Custom Format instead.
"The Total is "#,###.00
Gord Dibben Excel MVP
You can use a Custom Format instead.
"The Total is "#,###.00
Gord Dibben Excel MVP