View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default in excel, how do i remove quotes from column of 700 names

select the column
edit-replace enter a quote mark in find
enter nothing in replace
select replace all

"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...