Hi,

I have to clean data like as mentioned below on regular basis.I need macro to find and replace the values quickly.

Employee Count
1000-9999
1000-9999
1000-9999
1000-9999
1000-9999
100+
100,

I have to keep all the data after hyphen that is 9999
and remove trailing + and commas all in one function.
The macro should help me to clean these three requirements.
Thanks,