Hi Sandeep I hope you have recd the attached file now... The process explained to you... was used to derive the result you required...
By the way do you use MS Office 2003? Regards, Andy On Wed, Jun 24, 2009 at 8:50 PM, Sandeep <sandymau...@gmail.com> wrote: > Thanks Aindril, but there is no attached file and the this process is not > working. > > ----- Original Message ----- > *From:* Aindril De <aind...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, June 24, 2009 7:08 PM > *Subject:* $$Excel-Macros$$ Re: replace when large data in cell > > Dear Sandeep, > > Please find attached the updated file. It shd not be an issue. > Just say select all... then Ctrl + H to open the Find Replace box... > In Find type " > In Replace type \" > > Then press replace all. > > Regards, > Andy > > On Wed, Jun 24, 2009 at 6:46 PM, Sandeep <sandymau...@gmail.com> wrote: > >> Hi Everybody, >> >> Please help me. >> >> I have a file with a lot of inverted commas " in cells which should be \" >> and many cells have large data due to which 'find and replace' command not >> working and saying too long formula. >> >> How can I replace this. Please help me. >> >> Thanks You >> How can I replace >> >> >> > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
