How to imbed a cell reference in a text field?

Posted to microsoft.public.excel.newusers

external usenet poster

Posts: 61

How to imbed a cell reference in a text field?

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.

Thanks

--
Running Excel 2000 SP-3 on Windows 2000

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Maintaining cell reference after sorting	GRITS	Excel Discussion (Misc queries)	2	April 30th 23 07:42 PM
How to enter an Excel cell reference into a line of text in Excel	WUDFAL	Excel Worksheet Functions	2	December 5th 06 10:37 PM
Using an offset formula for the reference in a relative reference	Cuda	Excel Worksheet Functions	6	November 15th 06 05:12 PM
How do I put text and a cell reference in a text box?	Sarah Lefevre	Excel Discussion (Misc queries)	3	September 15th 06 12:57 PM
Goal Seek - reference a cell for "To value" field?	cchristensen	Excel Worksheet Functions	1	November 5th 04 07:27 PM

All times are GMT +1. The time now is 09:20 AM.

Menu

About Us