Would the '&' work for this problem. eg if A1 = "Pat" and B1 = "Hughes"
then the formula A1&B1 would return PatHughes, formula A1&" "&B1 would return
Pat Hughes?

To make the cell fit the text, without effecting other cells in the same
column, then use Format Cells/Alignment/Wrap text. Although this will effect
those in the same row.

Hope this helps.

Roger

"Pat Hughes" wrote:

I want to display the contents of a cell range in a text box. I know how to
put contents from one cell in a text box but I need to put the contents of 24
cells in my text box.

Or how can I change the length and height of cells below other cells without
changing the other cells length and height. Is there a way to put a line to
freeze panes to change the length and height of cells below the line?