Est. Budget: $40.00
I need someone to write some macros/scripts to help me automate an excel file.
Here's what I need... I think it will go very quickly for someone who has this expertise.
I will supply an excel sheet... I need you to:
1. shorten full state names to their two letter abbreviations
2. Lookup and assign a job category based on a job title
3. Be sure all data in text is not ALL CAPS (some is currently)