I was wondering how I would go about putting a cell's output into multiple cells and rows. For example, I would like to do a repeat function in a cell, depending on numbers in a previous sheet.
=REPT("thickness, ",A1-1)&TEXT("thickness",1)
A1 ranges from 5-56. In all cases, the output of this cell is greater than 5 columns wide. I can only have an output that is 5 columns and the remaining needs to go into rows. How would I be able to go about doing this? I would like output to be something like this....
thickness, thickness, thickness, thickness, thickness,
thickness, thickness
Thank you in advance. I just found out about this website today and there is some great information on it. It's too bad that I didn't find out about earlier.
Heidi
=REPT("thickness, ",A1-1)&TEXT("thickness",1)
A1 ranges from 5-56. In all cases, the output of this cell is greater than 5 columns wide. I can only have an output that is 5 columns and the remaining needs to go into rows. How would I be able to go about doing this? I would like output to be something like this....
thickness, thickness, thickness, thickness, thickness,
thickness, thickness
Thank you in advance. I just found out about this website today and there is some great information on it. It's too bad that I didn't find out about earlier.
Heidi