Hi All,
Baloo is facing some issues with the text to column. As in the attached text
file.
I am also pasting his initial mail for your reference.
Kindly help him, I would be too busy to look into these for a couple of
days.
Original Mail:
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
Regards,
Andy
On Fri, Jun 12, 2009 at 9:14 PM, Balachander S <sba...@gmail.com> wrote:
> Attached is the sample file
>
> Thnaks for the response
>
> S Baloo
>
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
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
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
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
