Thanks Dave. Excellent .. With Warm Regards,
CA. Ajay Mittal Finance Manager [cid:image001.jpg@01CC3B22.459EBEA0] Pipelines Division, Noida - 201 301 Tel: 0120-2448312 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dave Bonallack Sent: Tuesday, July 05, 2011 2:38 PM To: excel-macros@googlegroups.com Subject: RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING 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 [cid:image001.jpg@01CC3B22.459EBEA0] 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<mailto: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> [mailto: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<mailto: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/> [cid:image002.jpg@01CC3B22.459EBEA0]<http://www.excelforum.com/newreply.php?do=newreply&p=2079066> 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<mailto: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<mailto: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<mailto: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<mailto: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/> http://akoul.posterous.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 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 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
<<inline: image001.jpg>>
<<inline: image002.jpg>>