Re: $$Excel-Macros$$ Extract text from parentheses

2011-02-08 Thread rajan verma
Hi Please check attached File.. Rajan. On Mon, Feb 7, 2011 at 9:26 PM, San Pat wrote: > Hi All, > > I am trying to extract a texts from the* parentheses. > > > I have attached the sample file. I want to extract texts from the > **parentheses > from column A to Column G. > > > Please advice how

Re: $$Excel-Macros$$ Extract text from parentheses

2011-02-08 Thread Manoj kumar
Please find the attached... Regards, Manoj Kumar On Tue, Feb 8, 2011 at 10:56 AM, San Pat wrote: > Hi All, > > I am trying to extract a texts from the* parentheses. > > > I have attached the sample file. I want to extract texts from the > **parentheses > from column A to Column G. > > > Pleas

Re: $$Excel-Macros$$ Extract text from parentheses

2011-02-08 Thread §»VIPER«§
Dear Sandip, find the attachment. -- *Thanks & Regards Thamu * On Tue, Feb 8, 2011 at 10:56 AM, San Pat wrote: > Hi All, > > I am trying to extract a texts from the* parentheses. > > > I have attached the sample file. I want to extract texts from the > **parentheses > from column A to Colum

Re: $$Excel-Macros$$ Extract text from parentheses

2011-02-07 Thread ashish koul
type this in g2 =RIGHT(SUBSTITUTE(A2,")",""),LEN(A2)-FIND("(",A2)-1) On Tue, Feb 8, 2011 at 10:56 AM, San Pat wrote: > Hi All, > > I am trying to extract a texts from the* parentheses. > > > I have attached the sample file. I want to extract texts from the > **parentheses > from column A to Col

$$Excel-Macros$$ Extract text from parentheses

2011-02-07 Thread San Pat
Hi All, I am trying to extract a texts from the* parentheses. I have attached the sample file. I want to extract texts from the **parentheses from column A to Column G. Please advice how I can achieve this. Regards, Sandip* -- --