Windows 8 and 8.1 Forums

Excel Find & Delete problem

  1. #1

    Excel Find & Delete problem

    I'm trying to modernize a Wordpad inventory list to Excel 2013 with a problem.
    Item description & quantity are now pasted into the same Excel cell.
    It's written with item description followed by inventory account in ( ) Since the inventory is inaccurate we need to just delete all ( ) and numbers inside which vary from 1-6 digits.

    I tried Find & Replace with wildcards. I also tried the =Left and =Right functions after reading about them.

    It looks like this
    2" Caps (98)
    3" Caps (1257)
    4" Caps (188)
    6" Caps (89)
    5' Wire (12500)

    It should look like this
    2" Caps
    3" Caps
    4" Caps
    6" Caps
    5' Wire

    Thank you
    Last edited by pcRat; 10 Oct 2013 at 15:08. Reason: Major Correction

      My System SpecsSystem Spec

  2. #2

    N. Calif
    Posts : 2,588
    W10 Pro (desktop), W10 (laptop), W10 Pro (tablet), W10 (laptop)

    Here's a formula that will do what you say you wanted but I don't think it's really want you want.


    If you have the data in column A and put that formula into B1, then copy and paste it into the rest of the cells in column B, then you will end up with the text in column B minus the (xxx). With your example data it will look like this:

    Click image for larger version
      My System SpecsSystem Spec

  3. #3

    I appreciate that strollin but I'll have to try it later. Will post the results.
    Wonder how long it to come up with that word 'CONCATENATE' ?
      My System SpecsSystem Spec

  4. #4

    There was a space between the 2 columns of text but after it posted, the 2 columns joined.

    I corrected original post and I think strollin's formula will give needed results.
      My System SpecsSystem Spec

  5. #5

    Thank you strollin. It worked perfect.
    Just one more ? How do I make it work for the whole page at once?
    I know about grabbing the handle and pulling it down. Not that I'm lazy but because I want to learn what tools Excel gives me and how to use them.
    I tried inserting $ before A1 but that didn't work. (maybe that only works for Conditional formatting) which I learned about last week
      My System SpecsSystem Spec

  6. #6

    N. Calif
    Posts : 2,588
    W10 Pro (desktop), W10 (laptop), W10 Pro (tablet), W10 (laptop)

    Now that you fixed your original post it's what I thought you would have wanted in the first place. The concatenate function is no longer needed and the formula can be shortened to:


    You can't apply the formula to the whole sheet at once but you could write a VBA macro that would loop thru the rows on column A and do the same thing as the formula above.
      My System SpecsSystem Spec

  7. #7

    I understand what you mean about VBA macro.

    I also posted my original msg in another group.

    This was a different solution that works by splitting a whole column where needed. The response is below.

    Try the Text to Columns feature in the Data ribbon.

    Highlight the column with the data (only 1 column) then click on Text to Columns
    Select "Delimited" then Next
    Select "Other" and in the entry to the right type in "(" (without quotes)
    You should see 2 columns now
    Select Next and click in the 2nd column and select "Do Not Import Column"
    Click "Next" and you should have what you want
      My System SpecsSystem Spec

  8. #8

    N. Calif
    Posts : 2,588
    W10 Pro (desktop), W10 (laptop), W10 Pro (tablet), W10 (laptop)

    I've never used that feature but it seems to do the trick!
      My System SpecsSystem Spec

Excel Find & Delete problem
Related Threads
Hey guys. just finished formating my computer (using the built in windows 8 feature). once it was up and running i uninstalled all the built in stuff lenovo brings with the computer using revo uninstaller. in the procces i also removed all registry and files those programs left.. but now theres...
I have download a bad files and he have a ''Malware'' or virus, My Malware or my anti-virus have delete the infection but the document I can't erase and he have nothing in ? If he have a clue for that, give me, I appreciate ! :D Regards
Odd one this... I have a Sony Vaio Pro 13 laptop, running Windows 8.1. If I have a couple of Excel spreadsheets open, close the laptop lid, leave it a minute or so, then re-open the lid, the screen momentarily goes dark, then comes to life again. All open apps are OK with the exception of the Excel...
Hi...last year i brought the nvidia geforce 9500gt graphic card it's really works perfect.recently when i played games on my pc the are too slow but i don't know the what is the exact problem i mean is the games slow because of ram or system overheating or graphic card problem so i want to know...
excel 2013 problem on win8 in Software and Apps
Good times of the day :), I have excel 2013 installed on win8 and i have several excel files on the internet that i try to open simultaneously and here is the problem: sometimes when one file is open and i try to open another it doesn't open until I close the first one. Does anyone have a clue or...
Hello people, I have a notebook with win 8 and when I click on camera I see a galery of my photos and videos but I dont see how can I take more photos. I took some photos, and made some videos, now I'm stuck in this "gallery" When a menu appear is like: "crop ------ delete" How can I...
When I open Device Manager, I see a problem with one of the PCI Devices: 11931 I've tried automatically updating the drivers, but Windows 8 says it can't install the PCI Device. Windows 8 64bit on a Dell m301z Laptop. So I don't know which device is causing a problem or how to resolve it....
Eight Forums Android App Eight Forums IOS App Follow us on Facebook