Re: $$Excel-Macros$$ Re: Need a function or formula

2009-11-14 Thread Chandra Gupt Kumar
>> >> >> ------ Forwarded message -- >> From: Chandra Gupt Kumar >> Date: Tue, Nov 3, 2009 at 11:50 AM >> Subject: RE: $$Excel-Macros$$ Re: Need a function or formula >> To: excel-macros@googlegroups.com >> Cc: vatspoojav...@gmail.com &g

$$Excel-Macros$$ Re: Need a function or formula

2009-11-08 Thread Hemant Hegde
@Pooja Hi If you want an accurate solution, you start with a sample data, big enough to include all possible patterns of raw data. The initial sample you attached did not contain all possible patterns. =Len() =Mid(,,,) =Left(,,) =Right(,,) =ISERROR() =IF(,,,) =SEARCH(,,,) I suggest you to under

Fwd: $$Excel-Macros$$ Re: Need a function or formula

2009-11-08 Thread Pooja Sharma
Sharma On Wed, Nov 4, 2009 at 1:05 AM, Pooja Sharma wrote: > > > -- Forwarded message -- > From: Chandra Gupt Kumar > Date: Tue, Nov 3, 2009 at 11:50 AM > Subject: RE: $$Excel-Macros$$ Re: Need a function or formula > To: excel-macros@googlegroups.com >

$$Excel-Macros$$ Re: Need a function or formula

2009-11-02 Thread Chandra Gupt Kumar
: Monday, November 02, 2009 11:53 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need a function or formula Hi Kumar, Thanks for the help, but still two difficulties are there, which is mentioned in the sheet itself. I think you can and will resolve these problems too

$$Excel-Macros$$ Re: Need a function or formula

2009-11-02 Thread Pooja Sharma
:* Sunday, November 01, 2009 11:49 AM > > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: Need a function or formula > > > > Hi Pooja > > > > Pls find the attached sheet > > > > > Hemant Hegde > > 2009/10/31 Pooja Sharma

$$Excel-Macros$$ Re: Need a function or formula

2009-11-02 Thread Chandra Gupt Kumar
-Macros$$ Re: Need a function or formula Hi Pooja Pls find the attached sheet Hemant Hegde 2009/10/31 Pooja Sharma Hi All, I need your help in extracting some words (having defined format) from one cell in another cell. Attached is a sheet where I have mentioned the case and the

$$Excel-Macros$$ Re: Need a function or formula

2009-11-02 Thread Chandra Gupt Kumar
...@googlegroups.com] On Behalf Of Deepak Rai Sent: Sunday, November 01, 2009 1:01 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need a function or formula Hi Pooja, Please find the enclosed file with the solution. Regards, Deepak Rai On Sat, Oct 31, 2009 at 9:25 PM, Pooja

$$Excel-Macros$$ Re: Need a function or formula

2009-11-01 Thread Norman May
Pooja, Try the following formula in cell D6, then copy down: =IF(ISERROR(FIND("e",B6)),"",RIGHT(B6,((LEN(B6))-(FIND("e",B6)))+1)) Norman On Sat, Oct 31, 2009 at 10:55 AM, Pooja Sharma wrote: > Hi All, > > I need your help in extracting some words (having defined format) from one > cell in anoth

$$Excel-Macros$$ Re: Need a function or formula

2009-11-01 Thread Hemant Hegde
Hi Pooja Pls find the attached sheet Hemant Hegde 2009/10/31 Pooja Sharma > Hi All, > > I need your help in extracting some words (having defined format) from one > cell in another cell. Attached is a sheet where I have mentioned the case > and the solution I require. > > Hope you will help

$$Excel-Macros$$ Re: Need a function or formula

2009-11-01 Thread Deepak Rai
Hi Pooja, Please find the enclosed file with the solution. Regards, Deepak Rai On Sat, Oct 31, 2009 at 9:25 PM, Pooja Sharma wrote: > Hi All, > > I need your help in extracting some words (having defined format) from one > cell in another cell. Attached is a sheet where I have mentioned the ca