hi Tilak, Here is a very easy method. 1. open the txt file in notepad. 2. navigate each line of the text file by left/right arrow. 3. type the tab key where you need a column in excel. (Tab spacing in text file means next column in excel). i.e. In a excel; the phrases separated by a tab spacing in a txt file will be placed in a column and the next portion separated by a tab spacing will automatically be pasted in next column. 4. Type Enter where you want a next row in excel (next paragraph means next row in excel). For example: In a text file, if you type as follows; name Tab spacing address tab spacing phone tab spacing email and paste it in excel; the word name will be in the first column, the word address in second column, the word phone in third column and the word email in the fourth column. Hope it helps.
On 8/23/15, Aravind R <[email protected]> wrote: > you try by pressing left mouse button twice quickly to separate > columns which normal people do with mouse. > else, open that file in excel by selecting all files in files of type. > there, three steps import process is there. > > On 8/23/15, Tilakprasad Joshi <[email protected]> wrote: >> Dear Friends, >> >> I sometimes have to download a report which is in TXT format which >> means, all data in the Notepad with the column that would appear once >> the file is converted in to Excel. Can any of you provide step by step >> instruction how to convert TXT Notepad file in to Excel with the help >> of JAWS/NVDA. >> >> I am mentioning few steps that Sighted people use to convert Notepad >> file in to Excel. >> Data Tab>Data Tool>Text to Column Dialog Box >> Once this Dialog Box is opened there are Radio Buttons they select >> Fixwith Radio Button and click on Next, challenge comes here where we >> have to remove some line from Notepad to show as Column in the Excel >> Sheet, Example: if there is one Column in the Notepad as SR No. >> Sighted people remove some don’t know what exactly they do because >> they use a Mouse so SR No. will come as one header in the Column >> otherwise SR and No. will appear as a separate header in the Excel. >> Need your urgent help. >> Warm Regards, >> Tilak. >> >> >> >> Register at the dedicated AccessIndia list for discussing accessibility of >> mobile phones / Tabs on: >> http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in >> >> >> Search for old postings at: >> http://www.mail-archive.com/[email protected]/ >> >> To unsubscribe send a message to >> [email protected] >> with the subject unsubscribe. >> >> To change your subscription to digest mode or make any other changes, >> please >> visit the list home page at >> http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in >> >> >> Disclaimer: >> 1. Contents of the mails, factual, or otherwise, reflect the thinking of >> the >> person sending the mail and AI in no way relates itself to its veracity; >> >> 2. AI cannot be held liable for any commission/omission based on the mails >> sent through this mailing list.. >> > > > -- > nothing is difficult unless you make it appear so. > > r. aravind, > > D R O in bank of baroda, > > mobile no: +91 9940369593, > email id : [email protected], [email protected]. > > > > Register at the dedicated AccessIndia list for discussing accessibility of > mobile phones / Tabs on: > http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in > > > Search for old postings at: > http://www.mail-archive.com/[email protected]/ > > To unsubscribe send a message to > [email protected] > with the subject unsubscribe. > > To change your subscription to digest mode or make any other changes, please > visit the list home page at > http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in > > > Disclaimer: > 1. Contents of the mails, factual, or otherwise, reflect the thinking of the > person sending the mail and AI in no way relates itself to its veracity; > > 2. AI cannot be held liable for any commission/omission based on the mails > sent through this mailing list.. > -- Him Prasad Gautam Kathmandu, Nepal Register at the dedicated AccessIndia list for discussing accessibility of mobile phones / Tabs on: http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in Search for old postings at: http://www.mail-archive.com/[email protected]/ To unsubscribe send a message to [email protected] with the subject unsubscribe. To change your subscription to digest mode or make any other changes, please visit the list home page at http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in Disclaimer: 1. Contents of the mails, factual, or otherwise, reflect the thinking of the person sending the mail and AI in no way relates itself to its veracity; 2. AI cannot be held liable for any commission/omission based on the mails sent through this mailing list..
