Thanks Aindril,
There is still no files, I'm using Office XP. I had solve the problem by using
substitute() function.
(I don't have your file)
Is you did it by find and replace?
Is it possible in Office 2003?
----- Original Message -----
From: Aindril De
To: excel-macros@googlegroups.com
Sent: Wednesday, June 24, 2009 9:52 PM
Subject: $$Excel-Macros$$ Re: replace when large data in cell
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
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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
