ExcelVixen
New Member
- Joined
- Jul 21, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi. I am trying to delete a word in a string in column A, if the word is found in column B. how do i delete only the specific word found in the string and not the entire string in the cell? E.g. Cell A1 = The cat ate the rat ; Cell B1 = rat. I just want to delete the word "Rat" in A1. A1 result = The cat ate the ; The values differ in each cell in both columns. see image attached.
I have tried find and replace but it is tedious for thousands of rows of data.
thanking you in advance.
N
I have tried find and replace but it is tedious for thousands of rows of data.
thanking you in advance.
N