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 j...
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.