B
Biz
Hi,
I have a long column of phone numbers, and would like to program the
adjacent columns to autofill the State and City for the phone numbers.
The only way I can think to do this is to create a massive formula, but
including every single zip code and corresponding state, city seems
like a nightmare. Is there an easier way to to this? If there's not,
what's the best way to word the formula?
Thanks,
Biz
I have a long column of phone numbers, and would like to program the
adjacent columns to autofill the State and City for the phone numbers.
The only way I can think to do this is to create a massive formula, but
including every single zip code and corresponding state, city seems
like a nightmare. Is there an easier way to to this? If there's not,
what's the best way to word the formula?
Thanks,
Biz