delete certain text from a cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: kakster (kakster.13j8nj_at_excelforum-nospam.com)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 12:34:33 -0600

Greetings,

i have an excel sheet with about 2000 entries in it.
i only want to delete certain text in a column.

For example,

in a column i have cells with the following format:

First Name_Last Name_Middle Initial_(some info in here)

under scores are used here to represent spaces.

I want to delete everything except what's in parenthesis.

How do i do this?

Thanks,

Nick 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Q: assign field background color dynamically according to field values
    ... I need to assign background colors in an excel sheet ... I have Matrix with entries between 1 and 100, ... I need more subdivisions than I am willing to do ...
    (microsoft.public.excel.programming)
  • Re: calculating time in vba
    ... the same question was answered some hours ago by JE (originator name: ... Jus curious: Are you Nick??? ... Frank Kabel ... > I have an excel sheet where the user can enter a date ...
    (microsoft.public.excel.programming)
  • Re: Add last two values
    ... Jason Lepack ... entries from a column. ... I had to make sure the parenthesis were all in the correct spot. ...
    (comp.databases.ms-sqlserver)
  • Re: time calculations in vba
    ... End Sub ... eustasius@mail.com (Nick) wrote: ... > I have an excel sheet where the user can enter a date ... > not in excel worksheet and I could use some help... ...
    (microsoft.public.excel.programming)
  • SendKeys Method ignore parenthesis?
    ... I have lots of text on a excel sheet which I am trying to send to ... notepad and save in a text file, but the outcome text on notepad ... parenthesis, so SendKeys must be ignoring the parenthesis completelly, ... NooK ...
    (microsoft.public.excel.programming)