Find and remove data from a column

  • Thread starter Thread starter jlclyde
  • Start date Start date
J

jlclyde

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
 
Try this in P1:

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

Copy this down the column.

Hope this helps.

Pete
 
Try this in P1:

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

Copy this down the column.

Hope this helps.

Pete




- Show quoted text -
Click to expand...

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