Re: Split Numbers In Single Cell Across Columns
I have in cell (A1) "001 - 002, 004 - 006, 008" (These are separated by a space)
and insert entire row and paste in column wise.
Input:
A1 Cells "001 - 002, 004 - 006, 008"
Output:
Cells insert and paste below data
A1 Cells 001
A2 Cells 002
A3 Cells 004
A4 Cells 005
A5 Cells 006
A6 Cells 008