7 replies
Just do File open and chnage the type of document from xls to .txt, .csv etc.
Note Excel will expect the columns to be delimited (separated) usually by tabs or commas. I think there is way of changing which characters are used.
You can also have a bit of fun with numbers and dates as well. If it puts it all in the first column, it didn't 'see' the columns.
by john.a.wills
I might have worked things out from this, but dryflies' answer gives all necessary detail and is immediately applicable.
by dryflies
when you open a .txt or .csv file with excel, it launches the text import wizard autyomatically. you will have to choose whether the columns are fixed width or delimited and also if delimited, what the delimiting character is. You will also have the oportunity to see what your different choices do to the data in a preview window. one of the steps allows you to not import certain columns of data and to define what type of data is in each column (text, number, phone, etc.).
Have fun, it is a great tool.
by john.a.wills
Poster rated this answer.
by oz_media
by john.a.wills
by john.a.wills
This discussion is closed to new replies.
Trending Software posts
Sort by Trending