View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Justin Larson[_2_] Justin Larson[_2_] is offline
external usenet poster
 
Posts: 26
Default excel adds quotation marks when pasting text

I am also using Excel 2003.

Shoot me an email and I can forward the sheet I am using if you want.

I will try to replace "" with ", I'll have to see if there are any other
adverse effects, because it doesn't seem to double them up when the quotes
are a result of a formula pulling from another cell. I tried to make my
problem cell a formula, but that didn't work.

"Sheeloo" wrote:

I tested this on Excel 2003 and could not replicate the problem.

Assuming first and last quotes are put in by you, try searching for "" and
replacing with ".

Which version of Excel are you using?