One way:

Select the column. Choose Edit/Replace

Replace what: "
Replace with: <blank

Click Replace All

In article ,
Ayoaka wrote:

I am working in an excel spread sheet with data that I imported. The import
put an entire column of date in quotation marks and I would like to remove
them. all at once and not one by one. How, prey tell, can I do that?

Thanks...