Find a Word within Cell, then Replace Entire Cell with New Word in Excel?
I have an excel spreadsheet with 300 entries.
There's a 100 mix of cells that contain the following word - Bandwidth.
Some cells says the following:
Bandwidth 1 Bandwidth Check Bandwidth Field Bandwidth Out Bandwidth In etc
(with random numbers)
Here's what I want to do:
If the cell contains "Bandwidth" (like the above samples) then I want to
replace whatever is in there with just the word "Bandwidth."
So the columns will say:
Bandwidth Bandwidth Bandwidth Bandwidth Bandwidth Bandwidth etc...
A Find and Replace of "Bandwidth" just changes that word and keeps the
other text. I want to find where it appears and replace the entire cell
with "Bandwidth."
Can this be done with excel or notepad++?
No comments:
Post a Comment