+ Reply to Thread
Results 1 to 5 of 5

find/replace 00 with 0

  1. #1
    Registered User
    Join Date
    07-17-2009
    Location
    Paris
    MS-Off Ver
    Excel 2003
    Posts
    28

    find/replace 00 with 0

    Hi,
    I have a column of account numbers.
    The system has spit them out so that there is two zeros (00) instead of just one (0) in the center of number.
    For example; 010017 should be 01017
    I am not sure what to put in the Find / Replace boxes to take out one of the "0".
    Thanks,
    JP
    Last edited by jpnyc; 07-13-2011 at 12:02 PM.

  2. #2
    Valued Forum Contributor Sadath31's Avatar
    Join Date
    03-02-2011
    Location
    Dammam, Saudi Arabia
    MS-Off Ver
    Office 365
    Posts
    452

    Re: find/replace 00 with 0

    =left(a1,2)&mid(a1,4,25)

  3. #3
    Valued Forum Contributor Blake 7's Avatar
    Join Date
    10-01-2010
    Location
    Bogota, Colombia
    MS-Off Ver
    Excel 2010 64 bit and Excel 2007,
    Posts
    1,377

    Re: find/replace 00 with 0

    will there ever be a case whereby two zeros together is acceptable?
    Blake 7

    If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

    If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.

    http://failblog.org/

  4. #4
    Registered User
    Join Date
    07-17-2009
    Location
    Paris
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: find/replace 00 with 0

    yes - there could be but the "bad" ones always appear in the same place - the third number

  5. #5
    Registered User
    Join Date
    07-17-2009
    Location
    Paris
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: find/replace 00 with 0

    Thank you! Interesting solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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