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

A

Ayoaka

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

JE McGimpsey

One way:

Select the column. Choose Edit/Replace

Replace what: "
Replace with: <blank>

Click Replace All
 
J

John Bundy

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
 
B

bj

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

Ayoaka

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

Ayoaka

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

I really appreciate it!!
 
Top