text and data in same cell

  • Thread starter Thread starter kwrohde
  • Start date Start date
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.
 
im not quite following this can u put it in terms a 3 year old ma
understan
 
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
 
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
 
Right. The data is now text.

You can use a Custom Format instead.

"The Total is "#,###.00

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

keeping only data in cell and not formula 2
find multipule text strings within a cell 1
IF function 3
how do you 3
Text not wrapping in excel worksheet 1
Getting a Cell Value into a Macro! 2
Split hours and minutes in two different cells 4
drag and drop linked cel 3

Back
Top