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

NoS

New member
Joined
Jan 17, 2013
Messages
832
Reaction score
0
Points
0
Location
British Columbia
Excel Version(s)
Excel 2010
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?
 

Caladbolg17

New member
Joined
Jan 18, 2014
Messages
8
Reaction score
0
Points
0
Well, Okay is the only word I want to remove, the location of the word is different for some cells.
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
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.
 
Top