I have more than 1000 rows of data , I would like to break the data into 2 rows within the same cell in one of the column if the data contain "/".
A
1 ISN - 1234/ 009
2 ISN - 1234343434/ 005
3 ISN - 12/ 003
Change to
A
1 ISN - 1234/
009
2 ISN - 123434343/
005
3 ISN - 12/
003
Of course I could use "ALT + Enter" in each cell to break the data into 2 rows. However, is there any ways to do it more efficiently?
Bookmarks