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?

=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?

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?

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

perhaps

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"anon" wrote in message
...
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?

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),IND IRECT("B"&E1))

Biff

"anon" wrote in message
...
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?

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),IND IRECT("B"&E1))

Biff

"anon" wrote in message
...
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?