| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing a space-delimited txt. file right-justified into Excel
I have a space-delimited txt. file, whose cells need to be imported right
justified into Excel. The txt. file looks like this: Barney Fife Mayberry 20.00 15.00 10.00 55.00 Thomas Newark 15.00 10.00 5.00 30.00 Mabel Mattingly Louisville Kentucky 5.00 10.00 5.00 20.00 The names in the example above are not being used, but I do need the 4 columns on the right. I've been using the txt import wizard in Excel 2002, but it is formatted to import the data left-justified, so i have to manually fix each line. Does anyone have any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dollar sign left justified - data right justified - large space | Excel Discussion (Misc queries) | |||
| Output space-delimited file with quotes around text? | Excel Discussion (Misc queries) | |||
| Importing Comma delimited file | Excel Discussion (Misc queries) | |||
| Parsing a space delimited file into segments | Excel Discussion (Misc queries) | |||
| HOW DO I EDIT AN EXISTING FILE TO BE SPACE DELIMITED? | Excel Discussion (Misc queries) | |||
Threaded Mode
