pls attach the workbook with an eg will be easy 2 get it On Wed, Jun 24, 2009 at 6:55 AM, Bakul Patel <bakulpatel...@yahoo.com>wrote:
> give an example. that would be gr8. > > > > > --- On *Tue, 6/23/09, Pavan Kumar VVN <nagapavan....@gmail.com>* wrote: > > > From: Pavan Kumar VVN <nagapavan....@gmail.com> > Subject: $$Excel-Macros$$ Excel Tip of Week # 26 > To: excel-macros@googlegroups.com > Date: Tuesday, June 23, 2009, 12:46 AM > > Hi, > > Here's my contribution---- > > If you have N/A or any other data which is commonly filled in various cells > of a work book and you would like to replace all of them with a blank or any > other character, say, Y. > > > 1. Press Ctrl + F > 2. Type the text which you wish to find > 3. Click on Replace > 4. Type the text you wish the found text to be replaced with > 5. Click on Options > 6. In the drop down shown as Within, select Workbook instead of sheet > 7. Click on Replace All > 8. Bingo, all the text details are replaced in the workbook. > > Pavan Kumar Venuturupalli > > On Tue, Jun 23, 2009 at 9:22 AM, Rajesh Kunder > <kunder....@gmail.com<http://us.mc337.mail.yahoo.com/mc/compose?to=kunder....@gmail.com> > > wrote: > >> Thanks Ayush and everyone :-) >> >> Regards, >> Rajesh Kunder >> >> On Mon, Jun 22, 2009 at 7:49 PM, Ayush >> <jainayus...@gmail.com<http://us.mc337.mail.yahoo.com/mc/compose?to=jainayus...@gmail.com> >> > wrote: >> >>> >>> Hello Everyone, >>> >>> Please congratulate Rajesh Kunder for winning the Best Excel Tip award >>> of Week # 25. This is really great news that people are participating >>> in the weekly tip contest and sharing amazing tips and tricks. >>> >>> The tip submitted by Rajesh is as follows : >>> >>> Subject : Identifying Merged Cells >>> Tip : >>> 1. *Ctrl+F*. Excel displays the Find tab of the Find and Replace >>> dialog box. >>> 2. Click the Options button to make sure the Find and Replace >>> dialog box is expanded to show all options. >>> 3. Make sure the Find What box is empty. >>> 4. With the insertion point in the Find What box, click the Format >>> button. Excel displays the Find Format dialog box. >>> 5. Make sure the Alignment tab is displayed. >>> 6. Make sure the Merge Cells check box is selected (there should be >>> a check in the check box). >>> 7. Click OK to close the Find Format dialog box. >>> 8. Click Find All. >>> >>> This is new, productive and unique tip among all the tips by the >>> participants. I encourage you all to submit such great tips which will >>> help all members and let you win the prize. >>> >>> MANY MANY CONGRATULATIONS RAJESH !!!!!!!!!! KEEP IT >>> UP !!!!!!!!!!!!!!!!! >>> You are now nominated for monthly award and your name is published on >>> home page of this group. >>> >>> CHEERS !!! >>> >>> The competition of week # 26 is already started & you can submit your >>> tip in the thread mentioned below: >>> >>> http://groups.google.com/group/excel-macros/browse_thread/thread/7bd29ef9c24174fc/c3b3a8fa4d2ebeec#c3b3a8fa4d2ebeec >>> >>> Please participate and win wonderful prizes. >>> >>> KEEP POSTING !!!! >>> >>> Thanks and best regards, >>> Ayush Jain >>> >>> >> >> >> > > > -- > V.V.N. Pavan Kumar > > > > > -- Regards, Vinay Keni --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
