cell reference

  • Thread starter Thread starter janette
  • Start date Start date
J

janette

I have a cell that has text in it and I would like to
imput a cell reference within that sentence. Is there a
way to do this?

Example: v & C loss @ (here would be the cell
reference "sheet2 cell B3).

Help!
 
Janette,

To concatenate a string w/ a cell reference, you create a formula with the
string in quotes and 'join' the reference with an ampersand (&) and add the
cell reference after the & and the the quotes... It's easier to show then
explain so here it is ;-)

="v & C loss @ "&Sheet2!B3
 
Hi Janette!

If it's the contents of the cell you want use:

="My favourite track is " &A3& " but what's yours?"

But if it's the address you want then use:

="The cell you want is "&ADDRESS(ROW(A3),COLUMN(A3),4)& " I think"

But you might change the 3rd argument in the ADDRESS function for
different referencing (e.g. argument of 1 gives $A$3

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top