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.
that was opened in Word.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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.
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?
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
Try the Text to columns wizard in the data menu, it will split the data intoJPM 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?
columns based on any delimiter, comma, space etc.
Regards
Peter