Hello from a newbie (or should that read numpty?) Please can someone help?
I have a product list and need to identiy/separate out some products which contain the words "All Ride" in the product title. Unfortunately, the All Ride isn't always at the beginning of the title (eg it may say All Ride Valve or it may say Valve All Ride). Is there a way to do this?
TIA
you can apply a filter to the top row, then in the drop down list is "text filters" and you can select from that list equals, does not equal, all the way down to contains where you can put in "All Ride" and it will give you that list.
is that something you can work with?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
=isnumber(search("all ride", A1))
EDIT: Sambo's idea is better.
Entia non sunt multiplicanda sine necessitate
Thanks guys - that's brilliant! Now just got to rename approx 1000 products so the All Ride is at the beginning! Cheers
Row\Col Bla bla All Ride All Ride Bla bla B2: =TRIM(IF(ISNUMBER(FIND("All Ride", A2)), "All Ride " & SUBSTITUTE(A2, "All Ride", ""), A2)) All Ride Bla Blah All Ride Bla Blah Bla bla blah Bla bla blah
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks