afghanistan

  1. Y

    Formula to make list shorter

    Hi guys, I was wondering if somebody could help me with the following. I have three columns, if somebody dials 93xxxxxxxx numbers the rate wil be charged 0.1575, and if someone dials 9320xxxxx the rate will also be charged0.1575. In this case i want to delete the row with the prefix 9320...
  2. R

    longest prefix match

    Needs help in order to match longest prefix, As an example I have an excel which contains prefix list like below; Column A contains regions and Column B contains prefix. Destination Prefix Afghanistan 93 Afghanistan - Mobile - Afghan Telecom 9375 Afghanistan - Mobile - Awcc 9370 Afghanistan...
    • rahmanafzal
    • Thread
    • afghanistan longest match longest prefix match mobile prefix match
    • Replies: 1
    • Forum: Excel Questions
  3. G

    Create Comma Delimited One Row of Data from multiple rows

    Hi, I have a list of data and need it converted to one row per country: Country DIAL CODE AFGHANISTAN 93 AFGHANISTAN MOB AFGHAN TEL 9374 AFGHANISTAN MOB AFGHAN TEL 9375 AFGHANISTAN MOB AWCC 9370 AFGHANISTAN MOB AWCC 9371 AFGHANISTAN MOB MTN 9376 AFGHANISTAN MOB MTN 9377 AFGHANISTAN MOB MTN...
  4. U

    how to divide a cell into 2 cells?

    good time how may I divide a cell into 2 cells? for example: Afghanistan [+].................. Afghanistan [+] or better to say: how do I delete [+] from my cell? for example: Afghanistan [+].................. Afghanistan thank you:rolleyes:

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top