Excel 2007 : Find and Replace question in Excell 2007

[raedaljarrah]

Hi,

I have an excel file with a column that contains value similar to:

ABC DEF (xyz)

I need to remove the "ABC DEF" part as well as the "()" part from all cells in the entire column

In other words , I only need to keep the "xyz" part

Regards

[MarvinP]

Hi raedaljarrah and welcome to the forum.

Look at http://office.microsoft.com/en-us/ex...005203612.aspx

Using the above try searching for
??? ??? (
That would be 3 question marks, as space, 3 more question marks, a space and a left parin.

See if that works for a start.