Hi,
I have a consolidate list of the 7 digit no I wants make all the 7 digit
no to 16 digit like this
Actual DATA I wants Make Like this but in place of 0 I want only
space
1234567
0000000001234567
Please advice any formula for this.
Regards
Kailash
________________________________
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of San Pat
Sent: Tuesday, February 22, 2011 8:41 AM
To: excel-macros@googlegroups.com
Cc: ashish koul
Subject: Re: $$Excel-Macros$$ Help needed to extract data by MM/Year
Thanks this is what I was looking for!
On Fri, Feb 18, 2011 at 11:36 PM, ashish koul <koul.ash...@gmail.com>
wrote:
see if it helps
On Sat, Feb 19, 2011 at 11:13 AM, San Pat <myitems2...@gmail.com> wrote:
Hi Group,
I need a urgent help to extract data by given MM/Year from a raw data.
Basically, I am looking for a macro which will extract data from the raw
data for a given MM/Year. See the attached reference sheet.
Regards,
--
------------------------------------------------------------------------
----------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
Regards
Ashish Koul
akoul.blogspot.com <http://akoul.blogspot.com/>
akoul.wordpress.com <http://akoul.wordpress.com/>
My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
P Before printing, think about the environment.
--
------------------------------------------------------------------------
----------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
------------------------------------------------------------------------
----------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
