how to remove symbol in excel ?

  • computer
  • Student
  • Student
  • User avatar
  • Joined: Oct 12, 2004
  • Posts: 74
  • Status: Offline

Post November 19th, 2008, 4:41 am

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
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post November 19th, 2008, 4:41 am

  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Joined: May 28, 2003
  • Posts: 23407
  • Loc: Woodbridge VA
  • Status: Offline

Post November 19th, 2008, 8:05 am

A search and replace for ". )" (dot space close pareth.) works. I just tested
Replace with "." (dot)
"There's no place like 127.0.0.1 except for ::1."
Alexandria Networks. Leader in IT consulting for associations/non-profits, and small to medium sized businesses around the northern Virginia and Washington D.C. metro area.
  • computer
  • Student
  • Student
  • User avatar
  • Joined: Oct 12, 2004
  • Posts: 74
  • Status: Offline

Post November 20th, 2008, 7:10 am

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 85 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
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.