Deleting data in a column

[longbow007]

Hello, could some one please help me with the following?

I need a macro for Excel 2003 that will search column H (range: H2 to H5000) of my worksheet and delete the following word from each cell if it exists:

The word is: AUSTRALIA

Example: Cell H2 has the following text: PERTH, WA, AUSTRALIA

I need it to read: PERTH, WA

Also, I need the preceding comma and any spaces (usually one space) to also be deleted.

If any one could please help, it would be greatly appreciated.

Kind regards,

Chris

[davesexcel]

Try Ctrl & H
Find
, AUSTRALIA
replace with
Blank
Replace all

[longbow007]

Thank you davesexcel - your solution works well - greatly appreciated.

Cheers,

Chris.