Results 1 to 7 of 7

Thread: URGENT: Specific excel cell filtering

  1. #1

    Lightbulb URGENT: Specific excel cell filtering



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am in need of a step by step help on the query below.

    In an excel sheet, I need to first find out cells which contains the symbol '[' and delete all the characters which is before that irrespective of the character numbers. The cells are just text values and no formulas. How do we do that?

    Note: I am not an excel expert. So request a step by step guidance on this.

  2. #2

    Lightbulb URGENT: Specific excel cell filtering

    I am in need of a step by step help on the query below.

    In an excel sheet, I need to first find out cells which contains the symbol '[' and delete all the characters which is before that irrespective of the character numbers. The cells are just text values and no formulas. How do we do that?

    Note: I am not an excel expert. So request a step by step guidance on this.

  3. #3
    Are these Cells that contain a [ in a column or are they spread out randomly throughout the sheet ?

  4. #4
    If you can be more specific about how your sheet is layed out , we might can find a solution.

  5. #5
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,412
    Articles
    0
    Go to Edit|Replace

    or Home| Find & Select | Replace

    or hit CTRL+H

    Enter in Find What box: *[

    If you want to remove the [ also, then leave the Replace With box empty, otherwise enter a [ in the Replace With box.

    then click Replace All.


  6. #6
    Acolyte Jon von der Heyden's Avatar
    Join Date
    Mar 2011
    Location
    Stellenbosch,South Africa
    Posts
    24
    Articles
    0
    Hi

    NBVC has provided you with a manual solution here.

    If it's a VBA solution you are after, you could record the manual process offered by NBVC, although I would be inclined to go with an Evaluate(formula) method.

    Code:
    Public Sub Demo()
        If TypeName(Selection) = "Range" Then
            With Intersect(ActiveSheet.UsedRange, Selection)
                .Value = Evaluate("IF(ROW(),MID(" & .Address & ",FIND(""[""," & .Address & ")+1,255))")
            End With
        End If
    End Sub
    Regards,
    Jon von der Heyden

  7. #7
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    335
    Articles
    0
    @kjijujoseph Please only post your question in one forum, no matter how urgent it is!

    Threads merged!
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •