Thank you Dilip, but then it will not possible to revert back data in same
cell. There are many cell with this problem.
I found an alternate way using substitute() function.
Any way thanks you.
----- Original Message -----
From: Dilip Pandey
To: excel-macros@googlegroups.com
Sent: Wednesday, June 24, 2009 6:02 PM
Subject: $$Excel-Macros$$ Re: replace when large data in cell
Hi Sandeep,
One quick way could be, copy the data from cell and paste that into Notepad.
Now copy again data from Notepad and paste in another Excel tab, by clicking on
a single cell. This will distribute the data in different cells / rows.
After doing this, you can go ahead and use "Find and Replace" command.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Wed, Jun 24, 2009 at 5:16 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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
