Thread: Area Codes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kishore Kishore is offline
external usenet poster
 
Posts: 6
Default 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