$$Excel-Macros$$ Re: Excel Tip

2015-02-25 Thread Bill Q
A VERY useful and great tip. Thanks ! On Monday, 23 February 2015 10:07:10 UTC-5, Vabz wrote: > > Convert all date in same format: > > While receiving data from different sources many time it happens that > data received is not in same format due to various reason. > > One of the tedious activ

$$Excel-Macros$$ Re: Excel Tip of Week # 26

2009-06-26 Thread Pavan Kumar VVN
Sure, here you go. In the attached sheet, you have N/A displayed in sheets QF & SF. If you want to replace N/A with blank, use the following steps 1. Press Ctrl + F 2. Type N/A in Find What 3. Click on Replace 4. Do not type anything in Replace With 5. Click on Options 6. In the

$$Excel-Macros$$ Re: Excel Tip of Week # 26

2009-06-25 Thread vinay keni
pls attach the workbook with an eg will be easy 2 get it On Wed, Jun 24, 2009 at 6:55 AM, Bakul Patel wrote: > give an example. that would be gr8. > > > > > --- On *Tue, 6/23/09, Pavan Kumar VVN * wrote: > > > From: Pavan Kumar VVN > Subject: $$Excel-Macros$$ Excel Tip of Week # 26 > To: excel-

$$Excel-Macros$$ Re: Excel Tip of Week # 26

2009-06-23 Thread Bakul Patel
give an example. that would be gr8.   --- On Tue, 6/23/09, Pavan Kumar VVN wrote: From: Pavan Kumar VVN 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