Hello,
Everyday I am constantly creating call lists to reach out to prospects for my company. In my sheets I have the name of the individual/Business and numbers, I have to follow the DNC guidelines and hours I can solicit. With that being said I am trying to maximize my time by calling on est time zone earlier and pacific later. Is there a way I can create a master key where I can list all of the area codes for each time zone and have excel organize them for me?
The entire number is in one cell, is there a formula that can compare the first three numbers in a cell to a master key that then lists which timezone it is in?
612-240-6939
612-239-5529
312-344-0632
612-203-2147
202-374-3379
612-300-7689
803-394-1220
612-965-0427
617-416-9140
763-427-1444
313-753-0567
612-805-9095
763-999-0644
763-242-5959
763-234-4288
715-426-9505
704-819-1704
604-792-8804
Bookmarks