Hi,
Here is another option. It is slightly shorter, and doesn't produce a #VALUE!
error when the target cell does not contain the expected data.
=MID(A2,MIN(SEARCH({1,2,3,4,5,6,7,8,9,0},A2&1234567890)),11)
If your the 11 digit number always starts with a 1 or a 3, as it does in your
sample, then the formula could be further reduced to:
=MID(A2,MIN(SEARCH({1,3},A2&13)),11)
Regards - Dave.
From: rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING
Date: Tue, 5 Jul 2011 14:24:00 +0530
Use this In B2
=MID(SUBSTITUTE(TRIM(A2),"
","*",2),FIND("*",SUBSTITUTE(TRIM(A2),"
","*",2),1)+1,11)
From:
excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of MITTAL AJAY
Sent: Tuesday, July 05, 2011 2:07 PM
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING
I WANT TO EXTRACT 11 DIGIT NUMBER IN CLOUMN B.
Can anybody suggest a suitable formula ?
With Warm Regards,
CA. Ajay Mittal
Finance Manager
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312
From:
excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ashish koul
Sent: Tuesday, July 05, 2011 1:33 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file
i suggest you hide the workbook from which you are copying
the data if you dont want to show it to the user
http://akoul.blogspot.com/search/label/Hide%20and%20Unhide%20a%20workbook%20in%20vba
On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma <rajanverma1...@gmail.com> wrote:
No, We cant Copy the data from Closed
Workbook.. but we can get the Data by Using Full Reference of cell .. Like
='C:\Users\Xl_Lover\Desktop\[ForDownload[Sheet1]]Sheet1'!A1
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com]
On Behalf Of ankur
Sent: Tuesday, July 05, 2011 12:13 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ copy data without opening file
hi hanumant
you may find this to be useful
http://spreadsheetpage.com/index.php...a_closed_file/
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On
Tue, Jul 5, 2011 at 12:40 AM, hanumant shinde <arsfan2...@yahoo.co.in>
wrote:
Hi
friends,
is there any way where we can copy data from closed workbook "A" and
paste it
into workbook "B" which is open?
--
----------------------------------------------------------------------------------
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
--
Regards
Ashish
Koul
akoul.blogspot.com
http://akoul.posterous.com/
akoul.wordpress.com
My
Linkedin Profile
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
This
Message was sent from Indian Oil
Messaging Gateway, Refineries HQ, New Delhi, India. The information contained
in this electronic message and any attachments to this message are intended for
the exclusive use of the addressee(s) and may contain proprietary, confidential
or privileged information. If you are not the intended recipient, you should
not disseminate, distribute or copy this e-mail. Please notify the sender
immediately and destroy all copies of this message and any attachments.
--
----------------------------------------------------------------------------------
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
<<attachment: image001.jpg>>
<<attachment: image002.jpg>>
