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

  • Thread starter Thread starter Andreas2003
  • Start date Start date
A

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
 
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.
 
Try it with something entered in F20 ; I believe this is what Andreas means
by "the content of "F20"".

Rgds,
Andy
 
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
 
And the irony is that ½ the time OPs never return. You'll get used to it
Dave R, keep plugging away.

<bg>,
Andy
 
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.
 
maybe she can chime in?

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

Best rgds,
Andy
 
Back
Top