Hey guys,
Very interesting! I think most of the people have given "RIGHT", "MID" function. But what if the data is in between and there is no fixed character placing. I think we need to write vb code for this. I'm attaching a file. Pls revert. Regards Abhijit _____ From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of H Upadhyay Sent: Tuesday, October 21, 2008 7:26 PM To: excel-macros@googlegroups.com Cc: [EMAIL PROTECTED] Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ pls chk this Regds Harish Upadhyay AXIS BANK LTD. Solaris, Powai, Mumbai On 10/19/08, Mattathil M. Pradeep <[EMAIL PROTECTED]> wrote: Dears.. How to copy particular data from one cell ? attached excel sheet for your reference. Thanks in advance PRADEEP --- "This e-mail message may contain confidential, proprietary or legally privileged information. It should not be used by anyone who is not the original intended recipient. If you have erroneously received this message, please delete it immediately and notify the sender. The recipient acknowledges that ICICI Bank or its subsidiaries and associated companies, (collectively "ICICI Group"), are unable to exercise control or ensure or guarantee the integrity of/over the contents of the information contained in e-mail transmissions and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of ICICI Group. Before opening any attachments please check them for viruses and defects." --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
Book1.xls
Description: MS-Excel spreadsheet
