If I have something like:
0.04, 0.04, 0.09, 0.38, 0.67, 0.92, 0.94
in one cell and I want to split the 7 values going down 7 cells, so all the values are in cell B9 but I want each value to be in B9:B15?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityIf I have something like:
0.04, 0.04, 0.09, 0.38, 0.67, 0.92, 0.94
in one cell and I want to split the 7 values going down 7 cells, so all the values are in cell B9 but I want each value to be in B9:B15?
I usually use another app to separate it.
I'd do:
Open Notepad++. (It doesn't work on Notepad only)
Copy the values from the cell and paste on the Notepad++
Highlight the first ", " (comma and space in between the values) then copy (ctrl + C)
Ctrl + F for find
Click Replace Tab
Click on the radio button Extended at the bottom part.
Choose "\n", which means next line by typing it on the field next to "Replace with".
If anyone could make it a lot easier, that'll be great.