unable to search and replace quote marks (") in excel

  • ozzyosb100
  • Graduate
  • Graduate
  • User avatar
  • Posts: 191
  • Loc: FL

Post 3+ Months Ago

Unable to find quotes in excell using the
find or replace feature, am able to find phrases that contain quotes but
not the quotes themselves.
ie:
if the data were: "test quotes"

excel would find [ "test ] and [ quotes" ] but not a single
[ " ]

any ideas?

on a dell latitude d620, Win XP, office 2003

thanks
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Bogey
  • Genius
  • Genius
  • Bogey
  • Posts: 8388
  • Loc: USA

Post 3+ Months Ago

Did you try replacing the [ " ] anyway? I did it on my Excel, it found ( "test text" ) but I replaced the [ " ] in "test text" which it found to [ . ] and it only replaced the [ " ' to [ . ] keeping Test text intact with to dots on either sides of them. Excel just finds the exclamation marks and the text between them, but when replaced, only the exclamation marks get replaced. Hope that this helped you.
  • ozzyosb100
  • Graduate
  • Graduate
  • User avatar
  • Posts: 191
  • Loc: FL

Post 3+ Months Ago

it doesnt find any [ " ] to replace, it says that searching was finished and there are clearly many [ " ] in the spreadsheet.
  • erleg
  • Born
  • Born
  • erleg
  • Posts: 1

Post 3+ Months Ago

The answer to this challenge, from nearly 4 years ago, is CHAR(34)

You can use this nested in a function like so:
=SUBSTITUTE("test quotes",CHAR(34),"%",1)

Which would return %test quotes"

=SUBSTITUTE("test quotes",CHAR(34),"%")
Would return %test quotes%

This post still has a fairly high search ranking. Hope that this helps someone along!
  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

nice solution. Thanks for the update.

Post Information

  • Total Posts in this topic: 5 posts
  • Users browsing this forum: No registered users and 55 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.