Hi,

I'm using Office 2007 and have an Excel query.

I downloaded a sales report and where there is a description of the goods, I need to shorten it to two words but cannot seem to do this with Find and Replace.

For example I might want to replace these three descriptions :

A box of blue widgets
Twenty Five Blue Widgets from New York
Blue Widgets with a dash of green

with:

"Blue Widgets"

Essentially, is there a way of highlighting all the columns that contain a phrase, like "Blue Widgets"with other words at the beginning and end and then replace them with just the phrase "Blue Widgets"

I hope this makes sense