convert a .dat file opened in Word to excel?

J

JPM

How do I convert a file to excel. The file I wish to convert is a .dat file
that was opened in Word.
 
G

Gary''s Student

Just pull-down:
File > Open and type in the name of the file. The import wizard should
wake-up to help you.
 
J

JPM

Yes I am aware of the import wizard process - I guess I didn't ask the right
question. Once it is imported into excel - it doesn't line up in the columns
- is there a quick way to fix this or is it cut and paste?
 
P

PeterAtherton

JPM said:
Yes I am aware of the import wizard process - I guess I didn't ask the right
question. Once it is imported into excel - it doesn't line up in the columns
- is there a quick way to fix this or is it cut and paste?
Click to expand...
Try the Text to columns wizard in the data menu, it will split the data into
columns based on any delimiter, comma, space etc.

Regards
Peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To make pdf to work as word 1
Difficulty with compatibility mode and Track Changes 2
Convert PDF to Visio File or Editable PDF in Visio 0
I have lost 6 months work, how can i get my file back 1
Internal Data Integrity (Type 4) Details Needed 1
Converts HTML and PDF to Word 1
Default local file location - folder redirection slowness 0
Convert word to excel 1

Top