converting from text database to excell

[kosteczki]

I have a number of larger databses for some European lottos. Problem is they are all in a text filles. What would you suggest would be the best way to take that data and convert it into an excell spreadsheet where every column is a different number.

(1 has over 4k draws another somewhere areound 6k+ that's a lot of data entry)

 

[PAB]

Hi kosteczki,

Using Excels "Text to Columns" Function will Achieve the Required Results.
Put the Text File Data into a Spreadsheet in Column "A" for Example. Highlight the WHOLE Column, then Click :-

Data
Text to Columns
Delimited
Next
Check the Box that Fits the Delimitation of the Text File
Next
Finish

You may Need to Adapt the Above a Bit to get the Required Results, but that should Not be a Problem.

Hope this Helps.
All the Best.
PAB

 

[kosteczki]

Thanks PAB, that's one more thing i can add to the memory banks.
It was actually quite simple.
Thx again.

 

[kosteczki]

How about sorting. I Don't really need it but the results per cell are displayed in the order numbers where drawn.
Like 2 44 37 33 1 7
how could I arange these cells so they show up in order? is there even a way?

 

[PAB]

Hi kosteczki,

How about sorting. I Don't really need it but the results per cell are displayed in the order numbers where drawn.
Like 2 44 37 33 1 7
how could I arange these cells so they show up in order? is there even a way?

Lets Assume that the First Six Numbers are in Cells "A1:F1".

In Cell "H1" Put the Formula :-
=SMALL(A1:F1,1)
In Cell "I1" Put the Formula :-
=SMALL(A1:F1,2)
In Cell "J1" Put the Formula :-
=SMALL(A1:F1,3)
In Cell "K1" Put the Formula :-
=SMALL(A1:F1,4)
In Cell "L1" Put the Formula :-
=SMALL(A1:F1,5)
In Cell "M1" Put the Formula :-
=SMALL(A1:F1,6)

Copy these Formulas Down as Far as Needed.
Highlight ALL the Cells with Formulas in, and then, Copy, Paste Special & Values.

Hope this Helps.
All the Best.
PAB

 

[kosteczki]

again thank you very much.
Where do you find all these formulas I can never seem to find the one I need in the function list.

Thank you again

 

[PAB]

Hi kosteczki,

Where do you find all these formulas I can never seem to find the one I need in the function list.

If you are Looking for Something Specific on the Fly for Example, you can Use "Type a Question for Help" at the Top of the Spreadsheet. It will give you Several Options Related to the Question you Type.
There is also a Great Book Written by John Walkenbach called "Excel 2002 Formulas" ( or whatever Excel Version you are Using ) that will Provide the Vast Majority of Anything that you will Need to do.

Hope this Helps.
All the Best.
PAB

 

[kosteczki]

Thank you,