Create a list in one cell

Copper Contributor

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:

Christina240_0-1686857343691.png

To this:

bourbons.PNG

Thank you.

1 Reply

@Christina240 

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.