 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008Find 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 Try this in P1: =IF(LEFT(K1,12)="Parent Sheet",RIGHT(K1,LEN(K1)-19),"") Copy this down the column. Hope this helps. Pete > 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 [quoted text clipped - 6 lines] > Thanks in advance, > Jay > Try this in P1: > [quoted text clipped - 18 lines] > > - Show quoted text - Pete, I had to subtract more from the Len, but this works great. Thanks, Jay You're welcome, Jay - thanks for feeding back. Pete > Pete, > I had to subtract more from the Len, but this works great. > Thanks, > Jay |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.