Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to reformat text data before or after importing to Excel
I have a text file that is in tab delimited columns, except that certain rows
of the text file don't fit the columns. Like this: ID #/Name Days Dollars 1234567 10 $200 Abrahamowitz, Alexander 7892346 5 $100 Smith, Bob As you can see, the second individual's information fits into some standard column breaks, but not the first. When I import the text into Excel, I cannot automatically break the information into even columns because of this problem. This is a very long list and making the changes individually defeats the purpose of importing this into Excel. Is there any easy way to reformat the original .txt file before importing it, or reformatting after it is imported? Thank you for your help. -Patti |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data for CSV into Excel using VBA | Excel Discussion (Misc queries) | |||
importing data into excel | Excel Discussion (Misc queries) | |||
Numbers/Text data missing from excel to excel query? | Excel Discussion (Misc queries) | |||
Importing Data | Excel Worksheet Functions | |||
create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) |