Formula for deleting "

[Dalvi]

Hi,

I have imported a CVS file delimited on commas.
I got "" in beging and end along with numeric data in each
cell. Data is in more than 1000 rows with 10 columns.

I want to remove these commas and change the cell format
to numeric without lossing any numerical data.

Thanks in advance.

 

[Frank Kabel]

Hi
have you tried 'Edit - Replace' for this operation?.
You may also have a look at:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall