CODEWITHSUNDEEP
excelvbaexcel-formula
nichkhun
nichkhun

Reputation: 5

How to find and replace exact match text but not match entire cell contents

So basically just find and replace but some of my data is so messy

For example I wanna find the word "cat" and replace it with "mr.cat"

but there are some word like "redcat" that will show up in my search too

img

and If I use the match entire cell contents some word like "the cat" will not show

img2

Upvotes: 0

Views: 3222

Answers (1)

Pan
Pan

Reputation: 53

Add another column and include the following formula

 =IF(EXACT(A5,"cat"),"mr.cat",SUBSTITUTE(A5," cat"," mr.cat"))

example

Upvotes: 0

Related Questions