On Nov 12, 5:08*pm, "Don Guillett" wrote:
Show sample data or
* * * If desired, send your file to my address below. I will only look if:
* * * 1. You send a copy of this message on an inserted sheet
* * * 2. You give me the newsgroup and the subject line
* * * 3. You send a clear explanation of what you want
* * * 4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"srosetti" wrote in message

...

I have 2 column's that I wish to remove certain data from. *The cells
have various lengths in data, but each column starts and ends with a
certain char I want to remove.

For instance in Column B the cell data starts and ends with a " sign.
I need these removed.

In Column C the cells all start with a " sign and end with a ");
These symbols need to be removed from the respective column data. *I
have over 50,000 entries so..this is why I'm looking to automate it
with either a macro, vba, direct excel solution etc.

Any Ideas on the problem at hand?

Thanks



Because of the nature of the file.. I will only be able to send some
sample data.
I'll give some various examples of different types of data.



Sample Data Expected Data
Column B C Column B
C
"AGR30P" "01683"); AGR30P
01683
"AM30LP-P" "03340"); AM30LP-P
03340
"Regency" "10602-70301"); Regency
10602-70301
"3500 series" "11002"); 3500 series
11002
"4040-NAT" "10602-71202"); 4040-NAT
10602-71202
"6000-S-41001" "11002"); 6000-S-41001
11002
"GF540-286-SB" "39400"); GF540-286-SB
39400
"BGA48-BQARL" "03360"); BGA48-BQARL
03360


Ok, You should get the picture of what i'm doing from the sample
data. I picked random entries throughout the spreadsheet so it was a
fair sampling. I have to do this over 50,000 times so...

There is exactly this number of rows down.. 53,077 entries or rows of
data. They all basically look like this in Column B and C.

Hope this helps you peeps with seeing what I'm asking..


Thank You