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 <vatspoojav...@gmail.com> 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 -~----------~----~----~----~------~----~------~--~---
