Hi Basically if I run a macro it should quickly remove any unwanted data like shown below
The macro can be runned to any column not just the column A.
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 all the data after Over
and remove trailing + and commas all in one function.
The macro should help me to clean these requirements.
Let me know if you need any clarification

Thanks!