7 {{ upvoteCount | shortNum }}
7 {{ upvoteCount | shortNum }}

How do I remove the Exact Match Brackets in Excel?

by BethOconnell
5 replies
Hi,

It's long and complicated but I'm needing to remove the exact match brackets i.e [ ] from excel to do a vlookup function.

How do I do this?

Or is there a tool out there that can do this for a big bunch of keywords?

Let me know

Thx!
#brackets #exact #excel #match #remove
  • Profile picture of the author Entrecon
    Find and replace. Find bracket and replace with nothing. Make sure the partial cell option is selected or whole cell option is off...I forget which it is.
    Signature

    Visit My website http://kipferguson.com

    {{ DiscussionBoard.errors[5734687].message }}
  • Profile picture of the author tryinhere
    Originally Posted by BethOconnell View Post

    Hi,

    It's long and complicated but I'm needing to remove the exact match brackets i.e [ ] from excel to do a vlookup function.

    How do I do this?

    Or is there a tool out there that can do this for a big bunch of keywords?

    Let me know

    Thx!
    it already has a tool built in and is easy to use

    highlight the column with the exact keys listed
    press ctrl H
    in the find box select the front bracket [ then select replace all
    repeat with the back bracket ] and when done select save
    Signature
    | > Choosing to go off the grid for a while to focus on family, work and life in general. Have a great 2020 < |
    {{ DiscussionBoard.errors[5734692].message }}
    • Profile picture of the author BethOconnell
      Originally Posted by tryinhere View Post

      it already has a tool built in and is easy to use

      highlight the column with the exact keys listed
      press ctrl H
      in the find box select the front bracket [ then select replace all
      repeat with the back bracket ] and when done select save


      Thanks I tried this but now getting a new error:
      It mentions it may be a protected sheet so not sure now weird
      {{ DiscussionBoard.errors[5734777].message }}
      • Profile picture of the author tryinhere
        Originally Posted by BethOconnell View Post

        Thanks I tried this but now getting a new error:
        It mentions it may be a protected sheet so not sure now weird
        ok sure do this

        copy the list of keywords, open a new excel file and paste the keys into that and save the new file

        repeat the steps as above
        cheers
        Signature
        | > Choosing to go off the grid for a while to focus on family, work and life in general. Have a great 2020 < |
        {{ DiscussionBoard.errors[5734827].message }}
  • Profile picture of the author spoiledkid01
    The file you have downloaded is a .csv file. Which can not be saved after editing.
    Copy it to a new excel file and do what tryinhere said. That will work for sure.
    Signature

    My Goal Is To Make 90 Grand A Year - At Least

    {{ DiscussionBoard.errors[5734882].message }}

Trending Topics