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. Press Ctrl + F Type the text which you wish to find Click on Replace Type the text you wish the found text to be replaced with Click on Options In the drop down shown as Within, select Workbook instead of sheet Click on Replace All 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> wrote: Thanks Ayush and everyone :-) Regards, Rajesh Kunder On Mon, Jun 22, 2009 at 7:49 PM, Ayush <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 --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
