subject:"\"$$Excel\\\-Macros$$ EXTRACT NUMBER FROM TEXT STRING\""

RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

2011-07-05 Thread MITTAL AJAY

Thanks Rajan .

It is working fine.

With Warm Regards,

CA. Ajay Mittal
Finance Manager

[cid:image001.jpg@01CC3B23.4A34CC10]
Pipelines Division,
Noida - 201 301
Tel: 0120-2448312

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Rajan_Verma
Sent: Tuesday, July 05, 2011 2:24 PM
To: excel-macros@googlegroups.com
Subject: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

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@01CC3B23.4A34CC10]
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 
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@01CC3B23.4A34CC10]<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 
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. Jo

RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

2011-07-05 Thread MITTAL AJAY

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 
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 
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

Re: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

2011-07-05 Thread Manoj kumar

Hi,

you can use this formula as well in cell B2:-

=LOOKUP(99^99,--("0"&MID(A2,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A2&"0123456789")),ROW(INDIRECT("1:"&LEN(A2))



Best,
Manoj Kumar
On Tue, Jul 5, 2011 at 2:06 PM, MITTAL AJAY  wrote:

>  I WANT TO EXTRACT  11 DIGIT NUMBER IN CLOUMN B.
>
> ** **
>
> Can anybody suggest a suitable formula ?
>
> ** **
>
> *With Warm Regards,*
>
> * *
>
> *CA. Ajay Mittal*
>
> *Finance Manager*
>
> * *
>
> *[image: 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%20in%20vba
> 
>
>  
>
>
>  
>
> On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma 
> 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/
> 
>
> [image: 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 
> 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

RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

2011-07-05 Thread Dave Bonallack


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  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 
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

 

<><><><><><><><><><><><><><><><><><><

Re: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

2011-07-05 Thread ashish koul

hi Ajay

try this

=MID(B2,FIND(" ",B2,FIND(" ",B2)+1),FIND(" ",B2,FIND(" ",B2,FIND("
",B2)+1)+2)-FIND(" ",B2,FIND(" ",B2)+1))

On Tue, Jul 5, 2011 at 2:06 PM, MITTAL AJAY  wrote:

>  I WANT TO EXTRACT  11 DIGIT NUMBER IN CLOUMN B.
>
> ** **
>
> Can anybody suggest a suitable formula ?
>
> ** **
>
> *With Warm Regards,*
>
> * *
>
> *CA. Ajay Mittal*
>
> *Finance Manager*
>
> * *
>
> *[image: 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%20in%20vba
> 
>
>  
>
>
>  
>
> On Tue, Jul 5, 2011 at 12:53 PM, Rajan_Verma 
> 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/
> 
>
> [image: 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 
> 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/exceld

Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

2011-07-05 Thread Rajan_Verma

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 
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 
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

$$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

2011-07-05 Thread MITTAL AJAY

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@01CC3B1C.C8978CC0]
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 
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] 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/
[cid:image002.jpg@01CC3B1C.C8978CC0]

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 
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
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.quick

RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

Re: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

RE: Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

Re: $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

Re $$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

$$Excel-Macros$$ EXTRACT NUMBER FROM TEXT STRING

7 matches

Site Navigation

Mail list logo

Footer information