Can you please send the sample text file.. Regards, Andy On Fri, Jun 12, 2009 at 8:10 AM, Balachander S <sba...@gmail.com> wrote:
> May be this is very simple for you experts . I am unable to crack the > converiosn from Test file to excel for the data below. > > The fields are not aligned to draw column lines for import > the dtat is not of conistent length. > Only patterm I see is the text and numeric data nd spaces in between (these > are also not uniform) > > Any help possible as to how I proceed > > sba...@gmail.com > > > > Br Name AcNo Title Limit Excess > ACBalance > > r p road 1 god brother 1000000 2919.58 > 1002919.58 > > mysore 1 reliance star 74000000 100869954.98 > 100869954.98 > > tatabad ist street 12345 satyam computers p ltd 22500000 14480 > 22514480 > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
