date:20110625

Re: $$Excel-Macros$$ Extract values from cell

2011-06-25 Thread Dilip Pandey

Hi Kashan,

You can use following formula in column B and C respectively

=SUBSTITUTE(A1,C1,"")

=IF(VALUE(LEFT(MID(A1,SEARCH("ltr",A1)-1,50)))=0,MID(A1,SEARCH("ltr",A1)-2,50),MID(A1,SEARCH("ltr",A1)-1,50))

If you could provide some large set of data, that would have been
great to develop the full proof solution.  As of now, spreadsheet is
attached to handle current situation :)

Best Regards,
DILIPandey

On 6/26/11, Kashan Abbas  wrote:
>
> Hi guys ,
>
> Is there any formula that can extract particullar values or text from cell
> .I want to extract the values not on the basis of position of the character
> becuase it can be easily done through left or right function .My creteria is
> value base let say i want to extract values from below illustrated dummy
> collumn .In this example my target is to separte the product name and
> packing size in next collumns as :
>
> Result want to be produced
> Column bcollumn c
> deo3000   4lt
> deo3000   10ltr
>
>
> Availiable data
> Collumn A
> deo30004ltr
> deo300010ltr
>   
> 
>
> --
> --
> 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
>


-- 
Thanks & Regards,

DILIP KUMAR PANDEY, mvp
   MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

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


extracting text - By DILIPandey.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ RE: Macro To copy paste Selected Row

2011-06-25 Thread ashish koul

Attachment missing

On Sun, Jun 26, 2011 at 5:47 AM, Atul  wrote:

> Hi
>
> Attached is a sample file. I need a macro code to copy selected raws
> (yellow highlighted) from the liquidity tab of given spreadsheet and
> paste to other file say 'Book1'. The selection criteria would be based
> on Column A. I want to copy The first working day of each month. the
> day should not be either saturday, sunday or holidays. (you can have
> list of holidays on other tab approx 10 day in a given calendar year)
>
> Per my understanidng this taks can me done other way also, Copy entire
> spread sheet to Book1 and delete unwanted raws ( means raws not
> matching above criteria)
>
> Much wiill be appreciate if some one help me this.
>
> Thanks,
>
> Atul
>
> --
>
> --
> 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

Re: $$Excel-Macros$$ Extract values from cell

2011-06-25 Thread ashish koul

b1 =LEFT(A1,7)
c1 = RIGHT(A1,LEN(A1)-7)

On Sun, Jun 26, 2011 at 5:16 AM, Kashan Abbas wrote:

>  Hi guys ,
>
> Is there any formula that can extract particullar values or text from cell
> .I want to extract the values not on the basis of position of the character
> becuase it can be easily done through left or right function .My creteria is
> value base let say i want to extract values from below illustrated dummy
> collumn .In this example my target is to separte the product name and
> packing size in next collumns as :
>
> Result want to be produced
> Column bcollumn c
> deo3000   4lt
> deo3000   10ltr
>
>
> Availiable data
> Collumn A
> deo30004ltr
> deo300010ltr
>
>
>
> --
>
> --
> 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

$$Excel-Macros$$ Extract values from cell

2011-06-25 Thread Kashan Abbas


Hi guys ,
 
Is there any formula that can extract particullar values or text from cell .I 
want to extract the values not on the basis of position of the character 
becuase it can be easily done through left or right function .My creteria is 
value base let say i want to extract values from below illustrated dummy 
collumn .In this example my target is to separte the product name and packing 
size in next collumns as :
 
Result want to be produced
Column bcollumn c
deo3000   4lt
deo3000   10ltr   
 
 
Availiable data
Collumn A
deo30004ltr
deo300010ltr

  

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

$$Excel-Macros$$ RE: Macro To copy paste Selected Row

2011-06-25 Thread Atul

Hi

Attached is a sample file. I need a macro code to copy selected raws
(yellow highlighted) from the liquidity tab of given spreadsheet and
paste to other file say 'Book1'. The selection criteria would be based
on Column A. I want to copy The first working day of each month. the
day should not be either saturday, sunday or holidays. (you can have
list of holidays on other tab approx 10 day in a given calendar year)

Per my understanidng this taks can me done other way also, Copy entire
spread sheet to Book1 and delete unwanted raws ( means raws not
matching above criteria)

Much wiill be appreciate if some one help me this.

Thanks,

Atul

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

Re: $$Excel-Macros$$ Extract only 10 digit mobile number

2011-06-25 Thread Rajesh Nair

Hi ,

Check with formula   -->   Left(Column no,10)

Regards,
Rajesh. Nair

On Fri, Jun 24, 2011 at 2:58 PM, Brajesh Kumar Porwal <
brajeshkumarpor...@gmail.com> wrote:

> Dear Expert,
>
>
>  I need your help because I have more data of Multiple format. I want
> extract only 10 digit mobile number.
>
> Please find enclose example file.
> --
> --
> One Team One Dream One Goal
>
> Warm Regards,
> Brajesh
> 7503020750
>
> Life is Very beautiful !!!
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
> `•.¸.•´.
>
> --
>
> --
> 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

Re: $$Excel-Macros$$ join this group

2011-06-25 Thread kannan excel

Good Kaushik!!

I wish to invite you:


On Mon, Jun 20, 2011 at 8:58 PM, kaushik  wrote:

> Hi ,
>
> I wanna join this group
>
> --
>
> --
> 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

Re: $$Excel-Macros$$ Extract values from cell

Re: $$Excel-Macros$$ RE: Macro To copy paste Selected Row

Re: $$Excel-Macros$$ Extract values from cell

$$Excel-Macros$$ Extract values from cell

$$Excel-Macros$$ RE: Macro To copy paste Selected Row

Re: $$Excel-Macros$$ Extract only 10 digit mobile number

Re: $$Excel-Macros$$ join this group

7 matches

Site Navigation

Mail list logo

Footer information