text import wizard

P

philtyler

I'm migrating a huge database out of our current business software int
new software. I'm exporting into an Excel file so I can adjust inf
before mapping to the new software.

I've got the import wizard figured out but I'd like to *use it within
column* of info and not just to import a whole file.

are the functionalities of the wizard available within a column
 
J

JE McGimpsey

Many of the capabilities are available if you choose the Data/Text to
Columns... command

what exactly are you looking for?
 
P

philtyler

I needed to choose (") as the delimiter choice when I imported the ra
data. But now I have a column that has cells with numbers like this
53497 36 661.07 26 6 3035.17 03/05/99 0 04/21/99

You can see there are dollar amounts and dates in that mess. If I coul
use the wizard again within the column I could use "space" as th
seperator and produce meaning ful results. This column id 7248 row
long so I don't want to do it by hand :
 
D

Dave Peterson

This goes into one cell?
53497 36 661.07 26 6 3035.17 03/05/99 0 04/21/99

if yes, just import your text file and let it come in as one row.

then insert a dozen (enough so that you don't overwrite the existing data) new
columns to the right of that giant column.

Then do what J.E. suggested.
Select that column
Data|text to columns
(and use space as your delimiter.)

Hit Edit|Undo if you didn't make enough empty columns.
 
Top