Results 1 to 43 of 43

Need to delete multiple lines in cells but keep one

Threaded View

  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