I have a string of values in one cell that I want to break down into 2 columns, here is the format of the values within the cell;
28 Waist 28 Inseam,28 Waist 29 Inseam,28 Waist 30 Inseam,28 Waist 31 Inseam,28 Waist 32 Inseam,28 Waist 33 Inseam,28 Waist 34 Inseam,28 Waist 35 Inseam,28 Waist 36 Inseam,28 Waist 37 Inseam,28 Waist 38 Inseam,29 Waist 28 Inseam
It goes on like this for a good while, I am sure there is something I can run to break it up into columns correct? I need the first column to be the # waist and the second column # inseam.
Bookmarks