Results 1 to 3 of 3

Replacing the 0 by "" in each line until value <> 0

Threaded View

Coume Replacing the 0 by "" in each... 03-15-2010, 10:21 AM
rwgrietveld Re: Replacing the 0 by "" in... 03-15-2010, 10:38 AM
Coume Re: Replacing the 0 by "" in... 03-15-2010, 10:53 AM
  1. #1
    Registered User
    Join Date
    08-17-2009
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    31

    Question Replacing the 0 by "" in each line until value <> 0

    Hello,

    I am puzzled with this one.

    I have sheet with numerous columns.
    Col A - Col B - Col C - Col D - etc
    SKU1 - 0 - 0 - 125
    SKU2 - 12 - 0 - 14
    SKU3 - 0 - 56 - 0
    SKU4 - 0 - 0 - 1

    I would like to replace all the 0 in a row, starting from the left UNTIL I encounter a value so the above would become (I entered "" where I would like to remove the 0)
    Col A - Col B - Col C - Col D - etc
    SKU1 - "" - "" - 125
    SKU2 - 12 - 0 - 14
    SKU3 - "" - 56 - 0
    SKU4 - "" - "" - 1

    Any idea on how to tackle this one? I am puzzled :/

    Thanks in advance
    Ludo
    Last edited by Coume; 03-15-2010 at 11:03 AM.

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