Results 1 to 3 of 3

extract phone numbers to new columns

Threaded View

  1. #1
    Registered User
    Join Date
    06-22-2010
    Location
    Toon Town
    MS-Off Ver
    Excel 2003
    Posts
    12

    extract phone numbers to new columns

    I have one column that contains several possible phone numbers that looks like

    Office phone: 416.555.0442
    Office phone: 306.555.5322, Office fax: 306.555.5347
    Office phone: 306.555.7506, Office fax: 306.555.7500, Cell phone: 306.555.3584, Home phone: 306.555.6990

    I need to separate this into 4 individual columns just leaving the phone numbers in the column
    Last edited by NBVC; 02-28-2012 at 04:36 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1