Results 1 to 12 of 12

Remove only the previous 0

Threaded View

chief_abound Remove only the previous 0 11-21-2015, 12:22 PM
AB33 Re: Remove only the previous 0 11-21-2015, 12:58 PM
chief_abound Re: Remove only the previous 0 11-21-2015, 09:35 PM
Snuggles Re: Remove only the previous 0 11-21-2015, 01:08 PM
chief_abound Re: Remove only the previous 0 11-21-2015, 09:58 PM
jindon Re: Remove only the previous 0 11-21-2015, 02:09 PM
chief_abound Re: Remove only the previous 0 11-21-2015, 09:39 PM
shg Re: Remove only the previous 0 11-21-2015, 02:24 PM
chief_abound Re: Remove only the previous 0 11-21-2015, 09:39 PM
Jimbo77 Re: Remove only the previous 0 11-21-2015, 04:19 PM
chief_abound Re: Remove only the previous 0 11-21-2015, 09:54 PM
Snuggles Re: Remove only the previous 0 11-22-2015, 10:47 AM
  1. 11-21-2015, 12:22 PM #1
    chief_abound is offline
    Forum Contributor
    Join Date
    09-18-2015
    Location
    Republic of Korea
    MS-Off Ver
    2010
    Posts
    314

    Remove only the previous 0

    Snap85.jpg

    I've used the array formula

    --> {=RIGHT(A1,LEN(A1)-MIN(IF(MID(A1,ROW($A$1:$A$100),1)<>"0",ROW($A$1:$A$100)))+1)}

    However, it is too complicated.

    I would like to solve with regular expressions.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create Userform to Edit, View, Remove and Find next/ previous data
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-17-2015, 11:00 PM
  2. [SOLVED] Find certain word, copy and paste cell in previous row if previous row is blank
    By steven_e in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2013, 12:53 PM
  3. [SOLVED] Find last previous non blank value and summarise previous 6 months
    By Lady_Shaz in forum Excel General
    Replies: 7
    Last Post: 12-11-2012, 06:20 AM
  4. Is it possible to remove the archived previous versions of a excel file?
    By IndieAce in forum Excel General
    Replies: 2
    Last Post: 11-15-2012, 10:52 AM
  5. Table - lines compared to previous entries and values in another (the previous sheet0
    By racton in forum Excel General
    Replies: 0
    Last Post: 10-14-2011, 12:09 PM
  6. Copy formulaes to next column and make the previous data static(remove the formulaes)
    By deeps1403 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-05-2011, 03:16 AM
  7. Remove previous file reference
    By mkerstei in forum Excel General
    Replies: 3
    Last Post: 06-07-2006, 11:13 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1