in excel, how do i remove quotes from column of 700 names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
One way:

Select the column. Choose Edit/Replace

Replace what: "
Replace with: <blank>

Click Replace All
 
Select the column with the names, hit Ctl+H for the find and replace screen,
type " in the top one and leave the bottom alone, select replace all
 
select the column
edit-replace enter a quote mark in find
enter nothing in replace
select replace all
 
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.
 
OMG! I figured it out, but not without your help! Thank you! You saved me
tons of time!

I really appreciate it!!
 
Back
Top