Find and remove data from a column
 

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

Find and remove data from a column
 

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

Find and remove data from a column
 

On May 20, 7:48*pm, Pete_UK wrote:
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- Hide quoted text -

- Show quoted text -

Pete,
I had to subtract more from the Len, but this works great.
Thanks,
Jay

Find and remove data from a column
 

You're welcome, Jay - thanks for feeding back.

Pete

On May 21, 1:58*am, jlclyde wrote:
Pete,
I had to subtract more from the Len, but this works great.
Thanks,
Jay