+ Reply to Thread
Results 1 to 3 of 3

URGENT: Specific excel cell filtering

  1. #1
    Registered User
    Join Date
    06-03-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    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.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: URGENT: Specific excel cell filtering

    Hi Kjijujoseph,

    Welcome to the forum.

    You can use the below formula:-

    =IFERROR(MID(A1,SEARCH("[",A1)+1,LEN(A1)),A1)
    character after bracket sign.xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com

  3. #3
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: URGENT: Specific excel cell filtering

    To remove the data from every cell on the sheet you can do it in one go.
    Ctrl+H brings up the Find / Replace window
    In the Find field type this: *[
    In the Replace field type: [
    Now click the Replace All button

+ Reply to Thread

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