Excel/Access question

[Maximus]

If I wanted to copy a game log in notepad format, how do I paste it in excel (or in access) so that each field has its own cell?

DEFENSE TOT LOSS SACK FF FREC YDS TD INT RET AVG DEFLECTIONS SAFETIES
Dontrelle Wallace 13 3 0 0 0 0 0 0 0 0.0 1 0
Kory Minter 11 1 0 0 0 0 0 0 0 0.0 0 0
Shaun Williams 9 0 0 0 1 39 0 0 0 0.0 0 0
Tiki Rodgers 7 0 0 0 0 0 0 0 0 0.0 0 0
Leonard Nichols 5 1 0 0 0 0 0 0 0 0.0 0 0
Mike Houston 5 0 0 1 0 0 0 0 0 0.0 0 0
Benji Heyward 4 0 0 0 0 0 0 0 0 0.0 2 0
Howard Jean 4 0 0 0 0 0 0 0 0 0.0 0 0
Dana Hanks 3 0 0 0 0 0 0 1 16 16.0 1 0
Cory Claybrooks 1 0 0 0 0 0 0 0 0 0.0 0 0
Tom Strickland 1 1 0 1 0 0 0 0 0 0.0 0 0
Chris Randolph 1 0 0 0 0 0 0 0 0 0.0 0 0
Tommy Burnsides 1 0 0 0 0 0 0 0 0 0.0 0 0
Ted Tyson 1 0 0 0 0 0 0 0 0 0.0 0 0
Michael Andrews 1 0 0 0 0 0 0 0 0 0.0 0 0
Fred Doss 1 0 0 0 0 0 0 0 0 0.0 0 0


AS you can see above they all just look scatered about. This is what happends when I paste then into excel to. How do I get it to not do this? Thanks.

[JeremyThomas]

Use the "replace" function in notepad to replace each space with a tab. Then paste it in.

--Jer

[Purple Cowboy]

Actually, in Excel, you can paste the whole game log as is. Then highlight down the first column (from DEFENSE to Fred), go into the Data menu and select "Text to Columns." A wizard should pop up for you to customize the text to columns.

[Jonny2284]

if it's a simple txt file like that, either do the above or load the file into excel and it'll bring up the text import wizard, set it to delimited at the first page with a space as the delimiter on the second page and it loads fine.

[Maximus]

Blah! Thanks guys. I should have known that. :)

Thanks again.

[Maximus]

OK, heres one I am stumped on. I know the formula BUT I am not sure on how to format the whole column.

Using the exporter that Bob Hansen created, I want to edit the heights in the draft picks. For example, 78 = 6'5", 71 = 5'9".

I know a formula I'll list it below

=INT(A1/12)&"' "&A1-INT(A1/12)*12 &""""

OR I could use

=TEXT(78/12,"0")&" ft "&MOD(78,12)&" in" (im using "78" as an example)


OK, while both of these will do the job it will only change that cell with the number involved. I want to be able to format the whole colmun at once so that all of the numbers (such as 78, 68, 80, 81, ect) will be changed all at one time instead of each individually.

Any ideas? Thanks in advance.

[Paul]

I think you can just leave the column with the original value in inches, and create a new column on the side that has the formula to generate the height in feet & inches. And to format the entire column, just drag down the first cell with the formula to as many cells you need below.

Hope this helps.

[Maximus]

How do I format the colmun (that one cell so that the whole column follows)?

Thanks so much. :)

[Maximus]

I think you can just leave the column with the original value in inches, and create a new column on the side that has the formula to generate the height in feet & inches. And to format the entire column, just drag down the first cell with the formula to as many cells you need below.

Hope this helps.


Paul, thank you VERY much. It worked. I got it. Again, thanks. :D