phone numbers

  1. D

    Longest Call, Longest Call Phone Number and Longest Call Date

    Hi and thank you for all help in advance, I have a csv. file that I download and it gives me the data like this (not real data): A B C D <colgroup><col><col><col><col></colgroup><tbody> CallDate DialledNumber CallingNumber...
  2. H

    Merging data in cells and seperating by a comma in 1 cell

    Hi there I have been working and trying everything I can think of and using other examples to try and get this project finished but just can't seem to do it I have worksheet with up to as many as 200 or 300 phone numbers in row 1. Each cell holds its own phone number. Each time I run this...
  3. U

    Phone Number Format based on country

    Hi Guys, I have an excel with a column of phone numbers in varying formats. I need a system to clean the numbers based on country code which is stored in another column. For instance lets say the phone number column contains: 4921030012722 +49 (2103) 00 12722 12103001282 +1 (210) 300 1282...
  4. T

    Validating Phone Numbers (including international) without VBA?

    I have a form for entering customer information, and I want to validate whether an entry is a valid phone number. I need to accommodate international phone numbers as well as differences in formats. Most of the time we'll be copying/pasting stuff into this field, so I do _not_ want to force...
  5. B

    Sort Phone Numbers By Rows From Small To Large Or Large To Small

    Hi Friends I Have Phone Numbers Like This To Sort By Rows 66-66970877, 22-34567, 8764576890, 333-7465 (A1,B1,C1,D1) These Are Phone Numbers Which I Have To Short For Small To Large Or Large To Small Sorting Data In Row P1 To S1 22-34567, 333-7465, 66-66970877, 8764576890 (P1,Q1,R1,S1) P1 =...
  6. A

    converting value to phone number format

    Does anyone know how to use vba to format a phone number to the correct format? For some reason when a user enters a phone number with this format: (###)###-#### my script will not change the value to the correct format of: (###) ###-####. The only format difference is the space between the...
  7. D

    Phone Number Format

    Hi everyone, Sorry if this is an easy one. I have a very long list of phone numbers. They are currently in the following format: 02 1234 5678 I want to change this so they look like: 02 12345678 I want the cell to include the 0 at the front (not just look like it) so when you click on the...
  8. E

    How do I strip out all non-numeric characters?

    How do I strip out all non-numeric characters? I have 10,000 phone numbers, of which people entered in different formats, such as 212.123.1234 212 123 1234 212-123-1234 (212)123-1234 How do I strip out ALL the data/characters that are NOT numbers so the result is 2121231234 I want all...

This Week's Hot Topics

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
Top