How to combine a row letter and a value from a cell to get another value

[Andreas2003]

Hi

I would like to combine a result from a cell together with a row letter
to get a new value:

in C1 is the value 20
in D1 I would like to have the content of "F20" but the 20 should come
from C1 and concatenate with a single "F"

regards,
Andreas

 

[Andy Brown]

=INDIRECT("F"&C1)

Rgds,
Andy

 

[ozzie]

try ="F"&C1. the symbol in the middle is the "and" symbol.
.. whatever you put between the " " will be added to the
result of the cell.

 

[ozzie]

i couldn't get your solution to work...

 

[Andy Brown]

Try it with something entered in F20 ; I believe this is what Andreas means
by "the content of "F20"".

Rgds,
Andy

 

[Dave R.]

Ozzie--

The way the person asked the question could lead to more than 1 correct
solution. That is a problem I'm having now that I am trying to provide
answers to (the easier!) questions, then go back and re-read them and find
other ways to interpret what the person was asking.

ORIGINAL POST---------
I would like to combine a result from a cell together with a row letter
to get a new value:

in C1 is the value 20
in D1 I would like to have the content of "F20" but the 20 should come
from C1 and concatenate with a single "F"
--------------------------
One way to interpret is that he wants the content to EQUAL F20, with the 20
part coming from C1 (so your solution is right). Another way to interpret it
is that he wants the content to EQUAL the CONTENT OF F20, in which case
Andy's solution is right.

When I first read it, I interpreted in the way Andy did because the other
way seemed way too easy..

Dave

 

[Andy Brown]

And the irony is that ½ the time OPs never return. You'll get used to it
Dave R, keep plugging away.

<bg>,
Andy

 

[ozzie]

maybe she can chime in?

I believe that she means the results to be F20... as in if
c1 = fri, and the formula in b1 = +c1&"ends" then you get
the content of "friends" in b1.

 

[Harlan Grove]

maybe she can chime in?

...

FWIW, Andreas, as opposed to Andrea, is invariably a man's name.

 

[Andy Brown]

maybe she can chime in?

Andreas in several tongues is a male name, so perhaps "she" will.

Best rgds,
Andy