sueelliott
New member
- Joined
- Dec 5, 2013
- Messages
- 3
- Reaction score
- 0
- Points
- 0
I've got a huge spreadsheet with a column where cells are text filled with product titles. I have used Access queries: Like "*Mens*" and Like "*Shorts*" which finds all records with Mens Shorts in the text. I would like to use the same type of search in excel but if the search is true then a given number or text string is inserted into another column and corresponding row.
I guess this is possible but I really have no idea how.
Could someone please help?
I guess this is possible but I really have no idea how.
Could someone please help?