+ Reply to Thread
Results 1 to 4 of 4

Find and Replace using Wild Card characters

  1. #1
    Registered User
    Join Date
    10-16-2013
    Location
    Halifax Nova Scotia
    MS-Off Ver
    Excel 2011
    Posts
    2

    Find and Replace using Wild Card characters

    Hi I have what seems like a simple question

    I have a spreadsheet with a lot of item numbers on it.
    All the item numbers are 3 numbers long and have 1 as the first digit.

    I want to change all the first digits from 1 to 2.

    For example 101,102,103,104,105,106,107,108,109,110
    I want to change to 201,201,203,204,205,206,207,208,209,210

    I want to find all 1?? and replace with 2?? where ?? are the original second and third digits.

    The excel find and replace simply returns all "2??"

    Regards
    Darren

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Find and Replace using Wild Card characters

    welcome to the forum, Darren. try:
    =SUBSTITUTE(A1,1,2,1)+0

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Valued Forum Contributor
    Join Date
    10-29-2012
    Location
    Mojokerto,Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    554

    Re: Find and Replace using Wild Card characters

    try this
    =REPLACE(SUBSTITUTE(","&A1,",1",",2"),1,1,)

  4. #4
    Registered User
    Join Date
    10-16-2013
    Location
    Halifax Nova Scotia
    MS-Off Ver
    Excel 2011
    Posts
    2

    Re: Find and Replace using Wild Card characters

    Hi

    This solution will work well.

    Thanks
    Darren

+ 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. [SOLVED] REPLACE with Array List with Wild Card
    By dluhut in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-29-2013, 11:01 AM
  2. [SOLVED] Excel Replace Function with wild card: Possible?
    By alfykunable in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-27-2011, 12:59 AM
  3. SUMIF with Wild Card Characters
    By john6250 in forum Excel General
    Replies: 2
    Last Post: 07-14-2011, 02:12 AM
  4. Countif using Wild Card Characters
    By nebb in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2006, 08:20 PM
  5. Using wild card characters in array formulas
    By PJB Shark in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-19-2005, 12:06 PM

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