Forum Discussion
Create a list in one cell
I have a group of several values in one cell separated by commas. I don't want them to follow the previous value in the cell horizontally but look like a list of values in the cell. Usually I would just use Alt+Enter but I have several cells like this. Can someone tell me how to have the values list vertically in a cell and not horizontally without having to use Alt+Enter?
From this:
To this:
Thank you.
1 Reply
Select the cell or cells.
Press Ctrl+H to activate the Replace dialog.
Enter a comma followed by a space in the 'Findwe what' box.
Click in the 'Replace with' box and press Ctrl+J (this is a line break).
Click 'Replace All'.
Turn on 'Wrap Text'.
Autofit the row height.
