Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Where do I find
the list of area codes in US with their respective time zones and import it
on excel spreadsheet then have a blank field/cell to enter the area code which will provide me with the respective time zone as oppose to doing a ctrl f. over the entire worksheet. thanks people. I love community help groups like this, it gives me a sense of security that there are people who would like to help without cash in return (I hope:) |
#2
|
|||
|
|||
A quick search came up with many sites.
Here is one. http://www.bennetyee.org/ucsd-pages/area.html When copied to an Excel sheet, use a VLOOKUP formula to find results based upon a number you enter. Gord Dibben Excel MVP On Sat, 21 May 2005 10:16:01 -0700, "guideme" wrote: the list of area codes in US with their respective time zones and import it on excel spreadsheet then have a blank field/cell to enter the area code which will provide me with the respective time zone as oppose to doing a ctrl f. over the entire worksheet. thanks people. I love community help groups like this, it gives me a sense of security that there are people who would like to help without cash in return (I hope:) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Where do I find
Who says an area code can't contain multiple time zones and DST settings?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Edit + Find | Excel Discussion (Misc queries) | |||
find a cells from a range of cell | Excel Worksheet Functions | |||
Using the Find tool in EXCEL | Excel Worksheet Functions | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
VB Find and Replace | Excel Worksheet Functions |