Results 1 to 4 of 4

Remove brackets and data inside via macros example given

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-07-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    358

    Remove brackets and data inside via macros example given

    I have a document with about which has 25k+ rows of data and I'm wanting to remove part of each cell (if it exists)

    Example of RAW data:
    Lasso
    Frank (END)
    Elder
    Jude 
    Felipe (FROM)
    John (DES)
    Currently I'm using a slow method below, I'm wondering if Split could be used...

    Sub RemoveN()
            With Range("H:H")
                .Replace What:=" (FROM)", Replacement:="", LookAt:=xlPart, MatchCase:=False
                .Replace What:=" (END)", Replacement:="", LookAt:=xlPart, MatchCase:=False
                .Replace What:=" (LEG)", Replacement:="", LookAt:=xlPart, MatchCase:=False
            End With
    
    End Sub

    Final Data after removed...
    Lasso
    Frank
    Elder
    Jude 
    Felipe
    John
    Last edited by Hyflex; 09-22-2011 at 01:38 PM.

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