Hi Abhi, I think, the enclosed file can solve your problem. Regards
CA. Atul Singhal -----Original Message----- From: Abhijit Kanhegaonkar [mailto:[EMAIL PROTECTED] Sent: October 22, 2008 9:44 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ 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] <mailto:[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." This Message was sent from Indian Oil Messaging Gateway, New Delhi, India. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Book12.xls
Description: MS-Excel spreadsheet