Re: $$Excel-Macros$$ Re: Need a function or formula
DEAR POOJA , I FEEL IT WILL BE BETTER TO PROVIDE THE SOLUTION YOU YOU COULD EXPLAIN ME THE EXACT FORMAT OF THE SOLUTION REQUIRED. THIS IS SO BECOZ SOMETIMES YOUR EXTERNAL REFERENCE DOES NOT HAVE WORD "e-" or "e_"OR "E" AT ALL , WHEREAS ON THE OTHER OCCASSION THE SOLUTION IS 16 CHARECTER ,17 CHARECTER AND SO ON .. IT WOULD BE OF GREAT SUPPORT IF YOU COULD SPECIFY THE SOLUTION FORMAT LIKE THE SOLUTION STARTS WITH "e-" AVAILABLE IN EXTERNAL PO NO SUCCEDED BY THREE ALPHABETS FOLLOWED WITH "_" AND SIX DIGIT NO ... * THE ABOVE IS ONLY SAMPLE.. YOU MAY EXPLAIN ACCORDING TO YOUR REQUIREMENT .. REGARDS, C.G.KUMAR On Sat, Nov 7, 2009 at 8:29 PM, Pooja Sharma wrote: > Hi Kumar, > > Thanks for your kind help and support. But still when I'm trying this > function in my database it is not showing the accurate way as it should be. > I'm attaching the complete sheet where I've tried it with more data. > Hope you will again resolve this. > > Best Regards > Pooja 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 >> Cc: vatspoojav...@gmail.com >> >> >> Dear Pooja Jee, >> >> >> >> Let me first thank you for the confidence you have showered on me. >> >> Further, the solution is attached for your kind consideration. >> >> >> >> Regards, >> >> >> >> Kumar >> >> >> -------------- >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-mac...@googlegroups.com] *On Behalf Of *Pooja Sharma >> *Sent:* 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 difficulties are there, which is mentioned >> in the sheet itself. I think you can and will resolve these problems too. >> >> Regards, >> Pooja >> >> On Mon, Nov 2, 2009 at 1:05 PM, Chandra Gupt Kumar < >> kumar.bemlmum...@gmail.com> wrote: >> >> Dear Pooja Jee, >> >> >> >> Attached the solution. Hope it serves the purpose. >> >> >> >> Regards, >> >> >> >> Kumar >> -- >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-mac...@googlegroups.com] *On Behalf Of *Hemant Hegde >> *Sent:* 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 >> >> 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 me. >> >> Best Regards >> Pooja Sharma >> *** >> >> >> >> >> >> >> >> >> >> >> >> >> -- >> Best Regards >> Pooja Sharma > > > --~--~-~--~~~---~--~~ > -- > > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end
$$Excel-Macros$$ Re: Need a function or formula
@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 understand these functions yourself (these are not so difficult and powerful enough handle most of text data manipulations) and try to identify the pattern of your raw data and see if they: 1) BEGIN and/or END with a CERTAIN character(s) (eg "_", "e-" or a ) 2) have a FIXED LENGTH (eg: you ALWAYS don't want the first 5 digits of a number) 3) If none of the above are applicable, just see how you identify the information you require from a raw data, and tell the computer to do the same! Well the computer may ask you to give each and every break-up of the procedure! Good Luck :) Hemant Hegde - @All It would be nice if forums like this which have got a big number of experts and professional programmers should help a member to learn rather than being a place where we can post some files of which we forgot the password and and wish someone would break it for us. I had asked for a help about dealing with Importing code to a code module. But I got suggestions about how to search the web better with Google ;) and how to make the query short and interesting [yes! it did help! :)] But I am unhappy that no one bothered to answer my last few posts :( Good Day :) Hemant Hegde --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
Fwd: $$Excel-Macros$$ Re: Need a function or formula
Hi Kumar, Thanks for your kind help and support. But still when I'm trying this function in my database it is not showing the accurate way as it should be. I'm attaching the complete sheet where I've tried it with more data. Hope you will again resolve this. Best Regards Pooja 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 > Cc: vatspoojav...@gmail.com > > > Dear Pooja Jee, > > > > Let me first thank you for the confidence you have showered on me. > > Further, the solution is attached for your kind consideration. > > > > Regards, > > > > Kumar > > > -- > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Pooja Sharma > *Sent:* 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 difficulties are there, which is mentioned > in the sheet itself. I think you can and will resolve these problems too. > > Regards, > Pooja > > On Mon, Nov 2, 2009 at 1:05 PM, Chandra Gupt Kumar < > kumar.bemlmum...@gmail.com> wrote: > > Dear Pooja Jee, > > > > Attached the solution. Hope it serves the purpose. > > > > Regards, > > > > Kumar > -- > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Hemant Hegde > *Sent:* 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 > > 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 me. > > Best Regards > Pooja Sharma > *** > > > > > > > > > > > > > > -- > Best Regards > Pooja Sharma --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Need help.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need a function or formula
Dear Pooja Jee, Let me first thank you for the confidence you have showered on me. Further, the solution is attached for your kind consideration. Regards, Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Pooja Sharma Sent: 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. Regards, Pooja On Mon, Nov 2, 2009 at 1:05 PM, Chandra Gupt Kumar wrote: Dear Pooja Jee, Attached the solution. Hope it serves the purpose. Regards, Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Hemant Hegde Sent: 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 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 me. Best Regards Pooja Sharma *** -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Solution on the Data_Kumar.xls Description: MS-Excel spreadsheet
$$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. Regards, Pooja On Mon, Nov 2, 2009 at 1:05 PM, Chandra Gupt Kumar < kumar.bemlmum...@gmail.com> wrote: > Dear Pooja Jee, > > > > Attached the solution. Hope it serves the purpose. > > > > Regards, > > > > Kumar > -- > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Hemant Hegde > *Sent:* 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 > > 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 me. > > Best Regards > Pooja Sharma > *** > > > > > > > > -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Copy of Solution on the Data_Kumar.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need a function or formula
Dear Pooja Jee, Attached the solution. Hope it serves the purpose. Regards, Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Hemant Hegde Sent: 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 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 me. Best Regards Pooja Sharma *** --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Solution on the Data_Kumar.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need a function or formula
Hi Deepak, You have provide good solution but when I drag the list it shows #NAME? . Further you have used .xlfn in your formulae , may you please tell what it is exactly and what it does. Regards, Kumar _ From: excel-macros@googlegroups.com [mailto:excel-mac...@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 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 case and the solution I require. Hope you will help me. Best Regards Pooja Sharma *** -- Thanks, Deepak Rai --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need a function or formula
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 another cell. Attached is a sheet where I have mentioned the case > and the solution I require. > > Hope you will help me. > > Best Regards > Pooja Sharma > *** > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-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 solution I require. > > Hope you will help me. > > Best Regards > Pooja Sharma > *** > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Solution on the Data.xls Description: MS-Excel spreadsheet
$$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 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 case > and the solution I require. > > Hope you will help me. > > Best Regards > Pooja Sharma > *** > > > > -- Thanks, Deepak Rai --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Required Solution on the Data(1).xls Description: MS-Excel spreadsheet