How to delete similar words in exce

March 29, 2009 at 12:33:39
Specs: Windows XP
I have a spreadsheet that has 80 columns which contain the same word which want to delete but keep the remaining words. How can I do this?

Example:
White Sox at Diamondbacks
White Sox at Diamondbacks
Red Sox at Diamondbacks

Want:
White Sox
White Sox
Red Sox


See More: How to delete similar words in exce

Report •


#1
March 29, 2009 at 13:16:56
Edit, Replace:

Find What:
at Diamondbacks

Replace with:
"a literal blank"

MIKE


Report •
Related Solutions


Ask Question