Results 1 to 10 of 10

Advanced Find and Replace by Column

Threaded View

  1. #1
    Registered User
    Join Date
    07-28-2015
    Location
    chicago, illinois
    MS-Off Ver
    2013
    Posts
    28

    Advanced Find and Replace by Column

    I have attached an example spreadsheet.

    Here is what I am trying to do. I have a column with 5 digit extensions and a column for 11 digit extensions. These extensions are in two different ranges. 5XXXX and 7XXXX. I need a formula that will check the values in the column and if it finds a number that begins with 5XXXX then transform it into 1312555XXXX or if it finds a 7XXXX transform it into 1312777XXXX.

    I am sure this is easy to accomplish.

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Advanced replace and find formula help
    By jschleider in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-18-2014, 11:32 PM
  2. Replies: 3
    Last Post: 11-25-2014, 06:08 AM
  3. Advanced Find and Replace VBA Help
    By Remotruker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2012, 05:27 PM
  4. Advanced Find and Replace
    By lucydear in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2010, 08:58 AM
  5. Excel 2007 : advanced find and replace/apend
    By sip in forum Excel General
    Replies: 9
    Last Post: 07-16-2008, 09:00 PM
  6. Advanced Find and Replace Question
    By Ryan in forum Excel General
    Replies: 3
    Last Post: 08-06-2006, 02:00 PM
  7. Advanced Find and Replace Question
    By Ryan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-05-2006, 11:00 AM

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