how to remove symbol in excel ?

  • computer
  • Student
  • Student
  • User avatar
  • Posts: 74

Post 3+ Months Ago

Hi all

I have a excel file having data in each row in the form of simple text.
but I have a problem that every row has ) symbol before sentence.
Is it possible to remove all ) symbols.I can't use the replace option because there are so my text in brackets () too.

e.g.

1. )this is example 1.
2. )this (is) example 2.
3. )this is (example) 3.

so I just want to remove all ) just before the word "this"

Thanks in advance
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

A search and replace for ". )" (dot space close pareth.) works. I just tested
Replace with "." (dot)
  • computer
  • Student
  • Student
  • User avatar
  • Posts: 74

Post 3+ Months Ago

Thanks ATNO

I was also thinking for that but there are many lines without initial numbers,sorry for not mentioning it before.

What I did,I replaced all ")" with #.In this way ,atleast I know where is closing bracket ")" in between sentences.

Any way thanks once again.

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 65 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
 
cron
 

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