How to imbed a cell reference in a text field?
On Thu, 14 Dec 2006 06:20:01 -0800, Max wrote:
"LurfysMa" wrote:
=CONCATENATE("Cost at $",E7,"/hour.")
An alternative to try as well would be:
="Cost at "&TEXT(E7,"$#,##0.00") &"/hour"
Thanks.
That's the type of solution I was looking for, but couldn't find, when
I stumbled across the Concatenate function.
--
Running Excel 2000 SP-3 on Windows 2000
|