My data is visible but doesn't show up in the formula box.

Hi. I have data in excel that is on a dropdown menu. All of the data is visible but only one item shows up in the formula box. This is concerning because I need to separate the data but I cant. The easiest solution might be to go in each row, backspace and add commas. When i do this, it shows up in the formula box but it will take way too much time. Is there an easier way ?