View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
LurfysMa LurfysMa is offline
external usenet poster
 
Posts: 61
Default 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