View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default in excel, how do i remove quotes from column of 700 names

Edit/ Find and replace
Replace " by [nothing].
--
David Biddulph

"Ayoaka" wrote in message
...
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...