madhuchelliah
Board Regular
- Joined
- Nov 22, 2017
- Messages
- 226
- Office Version
- 2019
- Platform
- Windows
Hello all, i have multiple words in cell C4. Words are combination of alpha, numeric and symbols. Among the multiple words, the code has to find the word "FOR" and delete it along with the word before to the FOR. Please go through the example for better clarity. Thank you.
Value in cell C4 = XXX$%, AD024 FOR fds^&bjb ZZZZ RRRR, SSS-SSS, 58-2457R1 FOR asdsd , asdd,dsda
Expected Result= XXX$%, fds^&bjb ZZZZ RRRR, SSS-SSS, asdsd , asdd,dsda
Value in cell C4 = XXX$%, AD024 FOR fds^&bjb ZZZZ RRRR, SSS-SSS, 58-2457R1 FOR asdsd , asdd,dsda
Expected Result= XXX$%, fds^&bjb ZZZZ RRRR, SSS-SSS, asdsd , asdd,dsda