Good afternoon! I've scoured the internet for a while, but I just can't seem to find (or perhaps understand) quite what I'm looking for....
I receive a spreadsheet every morning of 200+ addresses. I need to find a way to replace state abbreviations (listed in their own cells) with their corresponding time-zone in order to effectively sort the list.
I work in a call center and its imperative to get eastern calls out first as we have a limited time frame.
Anyone have any ideas on how to get this to work? I've tried utilizing the IF, SUBSTITUE, or REPLACE formulas, I'm just beginning to learn formulas and I couldn't get them set up properly (assuming any of them are actually what I need)
Thanks in advance!