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 <vatspoojav...@gmail.com>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 <vatspoojav...@gmail.com>wrote: > >> >> >> ---------- Forwarded message ---------- >> From: Chandra Gupt Kumar <kumar.bemlmum...@gmail.com> >> 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 <vatspoojav...@gmail.com> >> >> 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 > -~----------~----~----~----~------~----~------~--~--- > > -- ---------------------------------------------------------------------------------- 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
