Using #s in column as column #s

[anon]

Assuming I have a column with #s, "1,5,7" can i get Excel to create a string
with the text from cells B1, B5, and B7?

[Aladin Akyurek]

=B1&B5&B7

anon wrote:
> Assuming I have a column with #s, "1,5,7" can i get Excel to create a string
> with the text from cells B1, B5, and B7?

[anon]

Aladin, you sort of missed my point, of course one can just put in B1&B5&B7,
but I want a function to do it because I have an entire column some cells may
have 1,5,7 others may be 3,4,13 or 1,21,16 etc. I want a function that will
take the numbers in the cell and call the same row #s. In other words, I
want the function to input B1&B5&B7 in the first cell, then B3&B4&B13 in the
next cell, that way I can just "drag" down to have it auto fill the rest of
the cells

"Aladin Akyurek" wrote:

> =B1&B5&B7
>
> anon wrote:
> > Assuming I have a column with #s, "1,5,7" can i get Excel to create a string
> > with the text from cells B1, B5, and B7?
>

[Bob Phillips]

=INDIRECT("B"&A1)&INDIRECT("B"&A2)&INDIRECT("B"&A3)

perhaps

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"anon" <[email protected]> wrote in message
news:[email protected]...
> Aladin, you sort of missed my point, of course one can just put in
B1&B5&B7,
> but I want a function to do it because I have an entire column some cells
may
> have 1,5,7 others may be 3,4,13 or 1,21,16 etc. I want a function that
will
> take the numbers in the cell and call the same row #s. In other words, I
> want the function to input B1&B5&B7 in the first cell, then B3&B4&B13 in
the
> next cell, that way I can just "drag" down to have it auto fill the rest
of
> the cells
>
> "Aladin Akyurek" wrote:
>
> > =B1&B5&B7
> >
> > anon wrote:
> > > Assuming I have a column with #s, "1,5,7" can i get Excel to create a
string
> > > with the text from cells B1, B5, and B7?
> >

[Biff]

Hi!

You'd be much better off by putting each number in a separate cell:

C1 = 1
D1 = 5
E1 = 7

Then:

=CONCATENATE(INDIRECT("B"&C1),INDIRECT("B"&D1),INDIRECT("B"&E1))

Biff

"anon" <[email protected]> wrote in message
news:[email protected]...
> Assuming I have a column with #s, "1,5,7" can i get Excel to create a
> string
> with the text from cells B1, B5, and B7?

[anon]

Thanks

"Biff" wrote:

> Hi!
>
> You'd be much better off by putting each number in a separate cell:
>
> C1 = 1
> D1 = 5
> E1 = 7
>
> Then:
>
> =CONCATENATE(INDIRECT("B"&C1),INDIRECT("B"&D1),INDIRECT("B"&E1))
>
> Biff
>
> "anon" <[email protected]> wrote in message
> news:[email protected]...
> > Assuming I have a column with #s, "1,5,7" can i get Excel to create a
> > string
> > with the text from cells B1, B5, and B7?
>
>
>