Hi.. Why dont you replace % character from that column.Just replace the % sign with space from cell.
On 10/23/08, SINGHAL, ATUL. <[EMAIL PROTECTED]> wrote: > > 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]> wrote: > > Dears.. > > > > How to copy particular data from one cell ? attached excel sheet for your > reference. > > > > Thanks in advance > > PRADEEP > > > > > > > > > > > face="Zurich BT" color=#0000ff size=1> > > "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 -~----------~----~----~----~------~----~------~--~---
