| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Area Codes
In the sheet1 i have
Australia - Adelaide 61-88x 0.0102 Australia - Melbourne 61-38,39 0.0102 Country - Area, Country Code, Rate In the Sheet2 I have Australia - Adelaide 61-88x 61882,61883,61884,61881 Australia - Melbourne 61-38,39 6138,6139 I need all the codes in one tab to each row Please let me know if anyone have solution for this in Excel. It should look Like below. Australia - Adelaide 61882 0.0102 Australia - Adelaide 61883 0.0102 Australia - Adelaide 61884 0.0102 Australia - Adelaide 61881 0.0102 Australia - Melbourne 6138 0.0102 Australia - Melbourne 6139 0.0102 Please help me if any one have solution |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Option button and Highlighting an area | Excel Worksheet Functions | |||
| Excel and zip codes | Excel Discussion (Misc queries) | |||
| How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
| Extra Row in Defined Print Area | Excel Discussion (Misc queries) | |||
| Volatile print area | Excel Discussion (Misc queries) | |||
Threaded Mode
