List in excel cell

[Tam12]

Hi,

I am trying to create a list of items in an excel cell.

I was told to use ' at the start of the cell to get my outcome but cannot seem to make it work.

My desired outcome is:

-text
-text
-text
-text

in a singular cell.

Thanks!

 

[Cubist]

Start with '-text, then do alt + enter to go to the next line.

 

[Joe4]

If you are starting each entry with a "-", if you format the cells as "Text" before making the entries in, it will see that as text and not as a minus sign.
If you want multiple rows in a single cell, use ALT+ENTER for the soft carriage return between each one.

 

[Tam12]

Start with '-text, then do alt + enter to go to the next line.

Perfect thanks!

 

[Tam12]

If you are starting each entry with a "-", if you format the cells as "Text" before making the entries in, it will see that as text and not as a minus sign.
If you want multiple rows in a single cell, use ALT+ENTER for the soft carriage return between each one.

Much appreciated thanks!

 

[Joe4]

You are welcome.
Glad we were able to help!