Try this in P1:

=IF(LEFT(K1,12)="Parent Sheet",RIGHT(K1,LEN(K1)-19),"")

Copy this down the column.

Hope this helps.

Pete

On May 21, 1:16*am, jlclyde wrote:
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