Can anyone tell me how to replace a slash (/) with a linefeed in Excel 2010? I have a very long worksheet with words, origins, and definitions. In the origins column, some rows show multiple places seperated by slashes. I want each item in the cell to be on a new line within the cell. Is this possible?
Right now the cell looks like this
Roman/ Celtic/ Baltic
I want the cell to look like this