How to imbed a cell reference in a text field?
On Thu, 14 Dec 2006 05:48:30 -0800, LurfysMa
wrote:
Is there a way to imbed the value in a cell in a text field?
Something like: "Cost at [E7] / hour.", where "[E7]" gets replaced by
the value in cell E7.
I found the answer. Use the concatenate function:
=CONCATENATE("Cost at $",E7,"/hour.")
Thanks
--
Running Excel 2000 SP-3 on Windows 2000
|