Software

Ask something
Discussion Locked

EXCEL: inserting data in between text

0 helpful
4 replies

by foxfire2010

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Could anyone advise how to insert a prticular value calculatd by Excel into a text. e.g.

say Cell A1 should = The value of should be used for the current month.

How do I insert a calculated value from another cell into the above text in A1 "The value of (actual value) etc.

4 replies

by firstpeter

Just an addition to the first response:

You may want to consider the TEXT() function to format the text string in a readable format (if, for instance, it's a date or a double value). To do this, replace the "&A1&" with:

For dates:
"& TEXT(A1, "m/d/yy") & "

For percentages:
"& TEXT(A1, "0.0%") & "

For numbers with decimals:
"& TEXT(A1, "0.00") & "

All of those can be modified further (just like when you format a cell), and many more can be used. It just makes things look much nicer than the value in many cases.

This discussion is closed to new replies.