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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---