+ Reply to Thread
Results 1 to 3 of 3

Macro to replace any 10 digit number in the cell which has other description

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    2

    Macro to replace any 10 digit number in the cell which has other description

    Pls help in creating macro which will replace any 10 digit number with XX in the same cell.
    The cell contains description and the position of the 10 digit vary.

    Ex: Nov10 2013 customer need help in calling. provide information 3424223434. Some more text

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Macro to replace any 10 digit number in the cell which has other description

    Keyword to make your search efficient: "regular expression"
    Do it (I mean do the search) you will quickly motice how powerfull tool regular expression is.

  3. #3
    Registered User
    Join Date
    01-16-2014
    Location
    chennai
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Macro to replace any 10 digit number in the cell which has other description

    Thanks for your reply. I tried doing but not success as i have to replace in the same cell in place of number with dummy text
    And have to do in macro as to reuse it further

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Color a single digit in a mult-digit number cell
    By Phyllis in forum Excel General
    Replies: 8
    Last Post: 09-30-2022, 04:22 PM
  2. Replace all one-digit number with two-digit numbers
    By sandykunaish in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-20-2013, 09:56 AM
  3. [SOLVED] Need Macro to pull only interface number not description.
    By watchdog4400 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2013, 08:39 AM
  4. Replies: 10
    Last Post: 11-24-2011, 10:34 AM
  5. How to replace the last digit in a cell with a letter
    By bramruis via OfficeKB.com in forum Excel General
    Replies: 16
    Last Post: 11-14-2005, 09:45 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