Macro That Will Convert Phone #s

Mar 27, 2009

I'm needing a macro that will convert a column of 10 digit phone numbers and break them out or convert them from a XXXXXXXXXX format to a XXX XXX XXXX format.

I want to be able to copy and paste a long column of 10 digit numbers then have the macro run down the column and cut or copy the area code (first 3 digits of the 10 digit string) - move it two columns to the left - paste it into that cell - return then cut the next 3 digits - move it one column to the left, and paste it.

View 4 Replies


ADVERTISEMENT

Convert Name / Address Phone In One Column To Multiple Columns

Feb 16, 2012

I have a long list of names, address, city state zip, and phone number, followed by the next name, address, etc. I need to now be able to bring each one into it's own column.

Example:
David Smith
123 Main St.
Denver, CO 12345
123.456.7890
Joe Blow
345 Happy Ave.
Oakland, CA 34567
567.890.1234

I need to convert it so that I would have

David Smith 123 Main St. Denver, CO 12345 123.456.7890
Joe Blow 345 Happy Ave. Oakland CA 34567 567.890.1234

View 2 Replies View Related

Phone Number Macro

Dec 11, 2007

I often have lists of badly formated phone numbers. I have created a number of macros that are quite good, but there is room for improvement.

Step 1:

Delete non numeric characters. This is a weak point - at the moment it is not working well (it removes characters from the entire sheet, rather than selected cells)

View 14 Replies View Related

Formula Or Macro To Fix Phone Numbers

Sep 17, 2009

I came up with this formula trying to fix phone number but it’s not working properly

FORMULA:
=TEXT(LEFT(SUBSTITUTE(a1, "-", "") & "00##", 10), "###-###-00##")

So basically I need a formula or macro that will fix the phone number for me.
Here is an example
78512312 it should be like this 785-123-0012

Or

785123123 it should be like this 785-123-0123. So if Len is 8 numbers long then insert two zeros counting from right to left. So if Len is 9 numbers long then insert one zeros counting from right to left.

View 2 Replies View Related

Extracting Phone # And Name

Mar 23, 2007

I have this data in cells A1-A7 (each line in the example below is a cell with the cells name to the left of the: and the value to the right of the
The colors are simply to show the matching data----there are no colors in the excel sheet

A1:Nordica Valley
A2:8888 bla oook nikk Rd $15,950,000
A3:Sumik/Arnov 120.443.8976/555.443.8976
A4:5+3. 13+ acre horse ranch in
A5:private canyon. Pool, barn/ more.
A6:Robinson 999.443.8976
A7:Cell7 is blank
A8:Jit/Song 587.678.6788

I wish to extract the Phone#'s and Names to columns B&C.

The data for this example would be broken down as follows:

B1:Sumik
C1:120.443.8976
B2:Arnov
C2:555.443.8976
D1:.5
D2:.5.........................................

View 10 Replies View Related

Macro To Convert Pdf

Nov 20, 2009

I just wanted to know do we have a macro which can convert PDF to excel......?

View 4 Replies View Related

Macro To Convert From A .csv To A .xls

Mar 8, 2006

I have a file that will open as a .csv file, is there a macro that can convert this to a .xls file and save?

View 9 Replies View Related

How Can I Convert In Macro

Feb 2, 2010

How can I convert this in my macro :

Combobox1 with the selection: 0,0023 Fuel
Combobox2 with the selection: 5000 Miles

Textbox1 = 11,50 ( result of Combox1 x Combobox2)

View 9 Replies View Related

Format Phone Number In VBA?

Nov 14, 2012

I'm looking to see is if there is a way to modify this code to format a phone number as (999) 999-9999. Right now it formats phone numbers as 999-999-9999.

VB:
Sub FormatPhoneNumber()
'Purpose: Formats a telephone number as 999-999-9999.
'In cases where more than one phone number is enter in

[Code].....

View 5 Replies View Related

How To Scrub A Phone List

Oct 15, 2013

I work for a charity and we have a new call list, about 1.2 million phone numbers. We have a list of about 1,000 numbers that we are not supposed to call again. How can I scrub the do not call numbers against the master list to remove both numbers? The master list has names in a column, city in another column, numbers in a column and city in a column. The do not call numbers I have are just listed in 1 column.

View 7 Replies View Related

Phone Format - Change Value

Jan 17, 2008

PHONE formatting. Is there a way to create a macro to format the VALUE of the phone to be either (XXX) XXX-XXX or XXX-XXX-XXXX ? I obviously can get it to look like this, but the value is just XXXXXXXXXX.

View 13 Replies View Related

Add 77 Plus Their Extension Text Phone

Jan 12, 2009

I have been able to successfully code a new email message one little thing I can't figure out is adding 77 plus their extension txtphone.

View 3 Replies View Related

Send SMS Message By Phone

Dec 8, 2009

I would like excel to send an SMS text message (via Skype maybe?)when a particular set of conditions arise in a spreadsheet. I am not sure if this would be best carried out with spreadsheet functions or vba, or if it is possible at all.

View 6 Replies View Related

Phone Number Formatting

Jun 22, 2006

I have a cell that NEEDS to be of the following format:

#### ######

I have set this up under formatting, custom... and when I type a number like this ...

01304999999 I get the result 01304 999999 PERFECT!

Unfortunately if I type this....

01304 999 999 I get this result 01304 999 999 which ain't good as it mucks up my Macro, whih incidentally is this...

appWD.ActiveDocument.Bookmarks("PMTelephone").Range = Format(strPMTelephone, "0#### ######")

View 10 Replies View Related

Phone Toll Formulas

Mar 13, 2008

I had two formulas for working with phone tolls. I moved offices a while back and can not find the disk I burned them to, and I cant remember them.

One of the formulas was like this: If the cell contains and or equals target number than put “incoming” (and/or if not than “outgoing”) in this (a different) cell.

I also had a formula that if the phone numbers came in 3 columns i.e. area code in one column, prefix in a second column and the last four digits in a third column, would combine all the numbers in one cell.

View 9 Replies View Related

Removing 1- Prefix In Phone #'s

Apr 9, 2009

I read the thread below on how to utilize the Subsitute function to remove periods and thought about being able to use it for this. However, I have some phone #'s in my list that contain multiple 1- scenarios in them because the area code or 3-digit prefix sometimes include a 1- also. How do I make the formula only look at the 1- for long distance and not any other 1- found in the phone #? I want to remove all of the 1- for long distance because we are trying to use a new autodialer that is pre-programmed with the 1-.

View 8 Replies View Related

Autofilter Phone Number

Jul 13, 2007

I am building a contact database in excel. I am using a userform to search, by autofilter, through several thousand contacts by any one of 7 criteria(account name, postal code,, account number, etc.). The only criteria that I cannot get to work is the phone number.

The numbers are entered in a ten digit string and the cells are formatted as phone numbers. i.e: 8005551212 = (800) 555-1212. When I run the search by the 10 digit number, the autofilter hides all results.

View 9 Replies View Related

Cleaning Up Phone Numbers With VBA

Aug 31, 2007

I am using VBA to enter customer information into a Microsoft SQL database. I have an excel sheet with thousands of customers listed. I will be using a While loop to process each line of the sheet. Part of the While loop needs to make any format changes necessary before the data moves over to the DB. So here is the issue:

How do I turn the following phone numbers:

(410) 273-9200
910-944-1232
276 623 4254
410 612 1100 Rob
(413) 786-1636 Cindy
1-800-783-4661
304) 842-5491 Sherry

Into a uniform layout? I would prefer ###-###-####

Each of the numbers above is an example from the list I have. There may be more variations (I have over 20 seperate lists to process, with over 10000 customers per list)

I imagine I need some process that will remove all character except numbers and then break the numbers up to add the hyphens back in at the appropriate places.

View 10 Replies View Related

4 Column Phone List

Aug 4, 2008

I have just created a phone list of about 70 lines on a single A4 sheet
A B C D
Name No Name No

One of the PA's now wants to know if she deletes a Name and No from say column A & B
can I make it all reconfigure to eliminate the blank spce.

So basically names fill column A & B first then overflow onto Columns C & D.

I think a macro is the only way to go here but the PA isn't keen.

View 9 Replies View Related

Phone Number Formatting ..

Jul 7, 2009

I have a list of telephone numbers... in every format you can imagine

123.456.7892
(123) 456 - 7892
1234567892
123-456-7892
etc...

is there any way to extract JUST the numbers...

so the format all phone numbers would take would be:

1234567892

?

View 9 Replies View Related

SMS Message To My Cell Phone

Oct 20, 2009

How can I send a SMS message to my cell phone if certain ocurrence happens in a cell. For example, if cell A1 = 1, then send a message to my cell phone.

View 9 Replies View Related

Dial Phone Number

Jul 20, 2007

I'd like to dial phone numbers directly from a specific column on a worksheet just by doubleclicking on them.

I found this code which I am trying to adapt to my use.

The hardware part is setup already (modem, phone line, etc.)

Private Sub Dial(Number)
Dim DialString As String
Dim FromModem As String
Dim dummy As Integer

' AT is the Hayes compatible ATTENTION command and is required to send commands to the modem.
' DT means "Dial Tone." The Dial command uses touch tones, as opposed to pulse (DP = Dial Pulse).
' Numbers is the phone number being dialed.
' A semicolon tells the modem to return to command mode after dialing (important).
' A carriage return, vbCr, is required when sending commands to the modem.
DialString = "ATDT" + Number + ";" + vbCr

I am getting an error message when I doubleclick that says :Runtime Error 424 , Object

Required and then I'm taken to the code line that is in Bold Yellow. Dealing with Comm

Ports is too much for me. I only know that my modem is in Com Port 4. If I'm told what to

View 9 Replies View Related

Convert CSE Formula To A Macro

Apr 20, 2009

I am using the following Control Shift Enter (CSE) formula to find a value.

View 4 Replies View Related

Convert Formula Into Macro

Mar 2, 2008

convert the formula into macro

I hv formula as following :-

=Left(B2, Find(" ", B2, 1) - 1)
I likt to convert into macro,

ActiveCell.FormulaR1C1=_ "=Left(B2, Find(" ", B2, 1) - 1)"
But it cannot work

View 9 Replies View Related

Cleaning Up Phone Number Lists?

Jun 22, 2014

I have an old customer list maintained by my company's previous owner in excel format that mostly stored numbers ###-#### format, but also some in ###-###-#### format.

My new list has always been maintained with numbers in (###) ###-#### format.

I have merged these two lists in a new excel file have begun the tedious process of cleaning up duplicates and bad data.

I have used conditional formatting to highlight duplicate numbers in the appropriate columns (L, M, N, O) in this case. However, it does't find matches in the other formats or perhaps the number with the old area code. I know the area code change could lead to false positives, but they should be minimal as this is a small business with mostly local customers. So what I'd like to find out is a formula for conditional formatting that will compare the last 8 characters in each cell (###-####) so as to eliminate issues of missing or different area codes. I would like it to check all of the columns for duplicate numbers not just within each column or within each row individually.

Also separate but related if possible to highlight a different color any cells with data not in any of these formats or if not in (###) ###-#### format if it's too much for all the formats.

View 8 Replies View Related

2007 Phone Number Formatting

Feb 25, 2009

I need to reformat phone numbers in Excel, and I am having trouble doing so. I do not have VBA experience, but I am somewhat familiar with functions in Excel. I need to go from 555-555-5555 to (555) 555-5555

View 4 Replies View Related

Automatic Phone Calls From A Spreadsheet

Aug 17, 2009

Is there anyway to make phone calls automaticly from a spread sheet

I'm calling old customers and it would be easy to just press a button and it will dial for me

View 13 Replies View Related

Find And Replace Phone Numbers

Dec 8, 2009

I have a bunch of phone numbers that I'm trying to reformat.

Say I wanted to replace any phone number like this: 1##########

With this: ##########

Keeping the numbers intact, just getting rid of the 1 in front of them. Can't figure it out for the life of me.

View 6 Replies View Related

How To Combine Two Columns To Make Phone #s.

Feb 1, 2010

I have two columns of numbers. The first is the area code and second is the phone number. How can I combine the two columns to make one with both: as in area code-phone number?

View 3 Replies View Related

Columns To Phone Numbers Format

Feb 1, 2010

Just got an answer to my phone number problem of converting two columns of numbers
to a single columns with the form XXX-XXXXXXX. Used =A1 & "-" & B1.

Works perfectly one one spread sheet and not at all in another.

When I enter the formula and hit return, instead of the correct result, all I get is the formula.

The format of the columns is the same on both spread sheets.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved