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
cid:image001.jpg@01CC1029.98246F90
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%20
in%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/
<http://spreadsheetpage.com/index.php/tip/a_vba_function_to_get_a_value_from
_a_closed_file/>
<http://www.excelforum.com/newreply.php?do=newreply&p=2079066> Image
removed by sender. Reply With Quote
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
<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<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
<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<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
<http://www.excel-macros.blogspot.com/>
4. Learn VBA Macros at http://www.quickvba.blogspot.com
<http://www.quickvba.blogspot.com/>
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
<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
<http://akoul.blogspot.com/> akoul.blogspot.com
http://akoul.posterous.com/
<http://akoul.wordpress.com/> akoul.wordpress.com
My <http://in.linkedin.com/pub/ashish-koul/10/400/830> 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
<<image001.jpg>>
<<image002.jpg>>
EXTRACT nUMBERS FROM TEXT.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
