Need help to automate the format cell values in Excel 2007

[narendrabr]

Hi,

I have to format some data like as mentioned below on regular basis.I need macro to find and replace the values quickly.
I have attached the sample worksheet with before and after tabs,
Employee Count
1000-9999
1000-9999
1000-9999
1000-9999
1000-9999
100 to 200
100>200
100+
100,
Over 1000
I have to keep all the data after hyphen that is 9999
I have to keep all the data after 'to' that is 200
I have to keep all the data after '>' that is 200
I have to keep the data after 'Over'
and remove trailing + and commas all in one function.
The macro should help me to clean these requirements.
Thanks,

[Fotis1991]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.You can add a sample workbook there.

Thread Closed.