Results 1 to 43 of 43

Need to delete multiple lines in cells but keep one

Threaded View

Javier20h Need to delete multiple lines... 10-11-2013, 12:20 PM
patel45 Re: Need to delete multiple... 10-11-2013, 12:43 PM
Javier20h Re: Need to delete multiple... 10-11-2013, 01:03 PM
patel45 Re: Need to delete multiple... 10-12-2013, 01:44 AM
Javier20h Re: Need to delete multiple... 10-15-2013, 12:25 PM
patel45 Re: Need to delete multiple... 10-15-2013, 01:30 PM
Javier20h Re: Need to delete multiple... 10-15-2013, 02:43 PM
Javier20h Re: Need to delete multiple... 10-15-2013, 02:49 PM
patel45 Re: Need to delete multiple... 10-16-2013, 02:37 AM
Javier20h Re: Need to delete multiple... 10-16-2013, 10:56 AM
Javier20h Re: Need to delete multiple... 10-16-2013, 04:32 PM
patel45 Re: Need to delete multiple... 10-17-2013, 02:37 AM
Javier20h Re: Need to delete multiple... 10-17-2013, 02:41 PM
patel45 Re: Need to delete multiple... 10-18-2013, 03:30 AM
Javier20h Re: Need to delete multiple... 10-18-2013, 11:47 AM
patel45 Re: Need to delete multiple... 10-18-2013, 12:35 PM
Javier20h Re: Need to delete multiple... 10-18-2013, 02:52 PM
Javier20h Re: Need to delete multiple... 10-18-2013, 12:53 PM
patel45 Re: Need to delete multiple... 10-19-2013, 03:02 AM
Javier20h Re: Need to delete multiple... 10-21-2013, 12:20 PM
patel45 Re: Need to delete multiple... 10-21-2013, 12:54 PM
Javier20h Re: Need to delete multiple... 10-21-2013, 01:56 PM
Javier20h Re: Need to delete multiple... 10-22-2013, 01:36 PM
Javier20h Re: Need to delete multiple... 10-22-2013, 05:52 PM
patel45 Re: Need to delete multiple... 10-23-2013, 02:36 AM
Javier20h Re: Need to delete multiple... 10-23-2013, 02:22 PM
patel45 Re: Need to delete multiple... 10-23-2013, 02:28 PM
Javier20h Re: Need to delete multiple... 10-23-2013, 02:39 PM
Javier20h Re: Need to delete multiple... 10-23-2013, 02:59 PM
Javier20h Re: Need to delete multiple... 10-23-2013, 07:44 PM
patel45 Re: Need to delete multiple... 10-24-2013, 08:18 AM
Javier20h Re: Need to delete multiple... 10-24-2013, 11:17 AM
Javier20h Re: Need to delete multiple... 10-24-2013, 11:28 AM
Javier20h Re: Need to delete multiple... 10-24-2013, 11:54 AM
patel45 Re: Need to delete multiple... 10-24-2013, 12:48 PM
Javier20h Re: Need to delete multiple... 10-24-2013, 01:50 PM
Javier20h Re: Need to delete multiple... 10-24-2013, 07:35 PM
Javier20h Re: Need to delete multiple... 10-25-2013, 05:37 PM
Javier20h Re: Need to delete multiple... 10-25-2013, 05:32 PM
patel45 Re: Need to delete multiple... 10-26-2013, 01:04 AM
Javier20h Re: Need to delete multiple... 10-28-2013, 02:43 PM
Javier20h Re: Need to delete multiple... 10-30-2013, 11:53 AM
patel45 Re: Need to delete multiple... 10-30-2013, 01:01 PM
  1. #1
    Registered User
    Join Date
    10-11-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    28

    Post Need to delete multiple lines in cells but keep one

    Need a Macro that does the following:

    For cells with multiple lines in a range
    1. Deletes all dates/text that are striked out
    2. Keeps only the remaining date/text that is next-in-line whether it be black and not striked out, colored, or italicized
    3. Deletes the other dates/text following that kept date/text
    4. Changes the color of the kept date/text to black (if it was red or a different color)
    5. Does not change the dates/text font format whether it be italicized or not
    6. Does not change the cells fill color

    Examples: the following are lists in individual cells. ALSO SEE ATTACHMENT for sample file
    ---------------------------
    08/01/12 *underlines indicate strikethrough
    06/01/13
    12/31/12
    05/31/13
    06/30/13
    06/30/13
    -----------------------------
    06/30/12
    01/31/13
    03/07/13
    06/05/13
    -----------------------------
    06/08/11
    12/09/11
    -----------------------------
    09/22/11
    10/31/12
    03/06/12
    -----------------------------
    09/01/10
    01/01/12
    N/A
    Design-Build
    ---------------------------------

    After running the macro, the result should look like this for each individual cell based on the previous examples
    -----------------------------
    06/01/13
    ----------------------------
    06/05/13
    ---------------------------
    06/08/11
    ---------------------------
    03/06/12
    ---------------------------
    N/A
    ---------------------------

    Any helpful comments or suggestions are welcome. Thank you for the help in advance.
    Javier20h
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro to delete lines where there are successive blank cells
    By Footley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-28-2012, 12:16 PM
  2. [SOLVED] Macro to Delete useless lines, rearrange by dates and skip lines between different days.
    By Tmc2159 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-12-2012, 02:15 PM
  3. Merged Cells and multiple lines
    By ATLGator in forum Excel General
    Replies: 2
    Last Post: 03-29-2012, 10:03 AM
  4. Compare cells to delete lines?
    By lancekeith in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-18-2006, 08:35 PM
  5. [SOLVED] Is there a way to delete multiple lines at the same time beside u.
    By cherry in forum Excel General
    Replies: 2
    Last Post: 04-11-2005, 02:06 PM

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