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

OMG! I figured it out, but not without your help! Thank you! You saved me
tons of time!

I really appreciate it!!

"Ayoaka" wrote:

Hi there, thanks so much for the info. One more question though. Where am I
choosing this edit/replace from? I tried the edit located next to file and
I'm not seeing any of the options you indicated.

"JE McGimpsey" wrote:

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