how do I convert a non exel tabulation to exel

06-29-06, 08:11 PM

dte123

I use a fixed tabulation in my job and I have noticed other people are
converting it to exel for ease of use. I do not want to have to ask and so I
need help.

06-29-06, 08:40 PM

Thansal

Depends on how it is formated.

The only one I have any experiance with is converting a txt file over
to Excel.

In the case of a txt file just open it in Excel and Excel will ask you
how you wana handel it. If the file is evenly spaced (ala tabs) then
it iwll pick up on this and convert, if it is sperated by a specific
character ("," ";" "-" what ever) you can tell it to break by those as
well.

hth
dte123 wrote:

06-30-06, 02:31 AM

JLatham

Thansal has given a good answer. I'll go one further with it. During the
input process it will show you where it thinks fields should start/end. It
may not always be right, especially if two or more fields are tail-to-head
like:
jlatham123456 NYC
It might think jlatham123456 is just one field instead of two. It will
allow you to define additional field breaks or delete any that it guessed
wrong on also. So just check on all of them the first time through it.

"Thansal" wrote:
[..]

Similar Threads
convert exel data to csv data I want to export my outlook contacts to gmail contacts. thanks
How I Wok with Exel Por Favor me puede alludar a usar exel Gracias
exel help Hi i'm working in exel, i have a column(A1) with these type of info in the column ( hbdn3j , hdfeyb , ijdnhf33k ) , and so on all the way down to 1000, now i need to add to...
How do I convert imperial to metric in Exel? I have just downloaded a Fitness Plan template but I prefer the metric system as I live in Denmark and I am used to metric.
How do I convert exel spreadsheet to works spreadsheet? I have Microsoft XP home edition. How do I convert an Excel spreadsheet to the XP edtion "works spreadsheet?