I am trying to set up a MID formula. I entered "=MID(H2,D2,1)". I don't
want the H2 to be the cell, but rather I want the value that I entered into
H2 to be the cell. In other words, in cell H2 I entered M12, and I want the
formula to refer to M12 rather than H2. Any ideas on how to make the value
of the cell (M12) be what the formula looks for rather than the cell H2?

Look in the help index for INDIRECT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Brian" wrote in message
...
I am trying to set up a MID formula. I entered "=MID(H2,D2,1)". I don't
want the H2 to be the cell, but rather I want the value that I entered
into
H2 to be the cell. In other words, in cell H2 I entered M12, and I want
the
formula to refer to M12 rather than H2. Any ideas on how to make the
value
of the cell (M12) be what the formula looks for rather than the cell H2?

Try: =MID(INDIRECT(H2),D2,1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Brian" wrote:
I am trying to set up a MID formula. I entered "=MID(H2,D2,1)". I don't
want the H2 to be the cell, but rather I want the value that I entered into
H2 to be the cell. In other words, in cell H2 I entered M12, and I want the
formula to refer to M12 rather than H2. Any ideas on how to make the value
of the cell (M12) be what the formula looks for rather than the cell H2?