How can you display the contents of an excel cell in a sentence

  • Thread starter Thread starter Ozinus
  • Start date Start date
O

Ozinus

Eg: The total cars sold this month was (Cell A35) which is (Cell D4) % of our
yearly total
 
Try this (all on one line):

="The total cars sold this month was "&A35
&" which is "&D4&" % of our yearly total"

Depending on the formats of the referenced cells, we might have to tweak it
a bit. See how that works.
 
Eg: The total cars sold this month was (Cell A35) which is (Cell D4) % of our
yearly total
Click to expand...


="The total cars sold this month was " & A35 &
" which is " & TEXT(D4, "0.0%") & " of our yearly total"

--ron
 
="The total cars sold this month was "&A35&" which is "&D4&
"% of our yearly total"

The above formula should all be on one line.
 
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

cell insertion in a sentence 3
Formatting a Sentence With TEXT Function 2
excel "IF" formula... if this possible ??? 0
Inserting a fixed value in to hundereds of cells 2
Moving a range name AND Contents 2
Cell Reference in a Formula 2
display sums from multiple worksheets on one worksheet 1
Splitting cell contents 4

Back
Top