I have a column of data that is very long. About ever 10 to 15 rows
the column says Parent Sheet 123456 (a six digit random number) then
measurements like 23 X 35. Sometimes the measurements will be 23 1/8
X 36 1/4. Is there a way to go through the coloumn and find Parent
Sheet and then remove the Measurements and put them in another
column? Column K is where Parent Sheet will be found and the next
available column is P. Formula or code will work for me.

Thanks in advance,
Jay