Excel: Search and Replace based on Rules
I have a list in Excel more than 3000 rows that I would like to research
and replace some words within the list based on another list.
For example:
List 1:
Blackcurrant Juice 500ml
Strawberry Juice 750ml
List 2:
have two columns (a: the word that I want to replace, b: the word that I
want to replace with)
A: Blackcurrant should be B: B/currant
A: Strawberry should be B: Strawb
And I want search in list 1 and replace the some word based on List two
Any ideas?
No comments:
Post a Comment