If cell contains text, then remove this text

Caladbolg17

New member
Joined
Jan 18, 2014
Messages
8
Reaction score
0
Points
0
Hi!

Is there any formula/macros for the following issue?

If cell contains some word/text, then this word should be removed from the cell, while the other text remains in the cell.

Like here word "Okay" should be removed, while other text stays
See the attachment for the reference.

Thanks!
 

Attachments

  • Excel_updated.xlsx
    8.9 KB · Views: 138
if cell contains SPECIFIC text, remove it

Hi Caladbolg17

This won't answer your question, but more like re-phrase it, in hopes of the "formula boys" arriving on the scene.

The cells you are working with have values (ie: the text/words) something like this

Good & chr(10) & Great & chr(10) & Okay

and display the words in the cell one below the other. You would like to remove the word Okay.

Questions:
Is Okay the only word you ever want to remove?
Does the location of Okay change within the different cells?
If there are other words that need removed as well? If yes, are they in a list in the workbook somewhere?
 
Well, Okay is the only word I want to remove, the location of the word is different for some cells.
 
Select the range, do a CTRL+H in the Find What field enter: Okay

in the Replace With field, don't enter anything.

Click Replace All.
 
Back
Top