A
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?
with the text from cells B1, B5, and B7?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Aladin Akyurek
=B1&B5&B7
A
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
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
B
Bob Phillips
=INDIRECT("B"&A1)&INDIRECT("B"&A2)&INDIRECT("B"&A3)
perhaps
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
perhaps
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
B
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
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
A
anon
Thanks
Biff said: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