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 kaushikmodak2...@gmail.com wrote: Hi , I wanna join this group -- -- Some important links for excel users: 1. Follow us on

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.

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

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

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 kashanabbas...@hotmail.comwrote: 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

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 atul_pate...@yahoo.com 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