Hi
I have a spreadsheet full of data and I need to extract only those lines of data which can be identified by the last three letters in a cell. Sorry if this description is not great but I am adding an example spreadsheet which highlights the rows I am trying to extract based on the contents in column B but only where column B ends in KY. Any assistance would be appreciated
Your example does not match your explanation. In the sheet you want to extract all rows where column B contains CS ???I am trying to extract based on the contents in column B but only where column B ends in KY
Pepe, thanks you are right. To clarify (hopefully) I need to extract all rows of data where the data in column B contains the code CS somewhere in the description.
Regards
After adding headers to the columns use the Filter then custom filter on "contains" CS and copy paste the result where necessary
or
select "does not contain " CS and delete the resulting rows
Pepe, many thanks that did the trick.
Regards
You're welcome -
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks