RoadBikeReview.com's Forum Archives - Non-Cycling Discussions


Archive Home >> Non-Cycling Discussions(1 2 3 4 )


Excel spreadsheet question(8 posts)

Excel spreadsheet questionDougSloan
Apr 28, 2003 10:55 AM
I want to copy the data from the two columns of this and similar web pages into an Excel spreadsheet, but have it go into separate columns. When I copy and paste now, it puts both columns of data from thd HTML page into one Excel column, which won't work for data analysis purposes. Any help? Thanks.

http://www.federalreserve.gov/releases/h15/data/wf/tcm10y.txt

Doug
re: Excel spreadsheet questionBruno S
Apr 28, 2003 11:02 AM
Don't copy and paste into Excel. Open the .txt file in Excel, (change the filter from .xls to .txt). Excel will display a series of dialog boxes to let you select how you want the data in the spreadsheet.
Here whacha do...Kristin
Apr 28, 2003 11:03 AM
They aren't in a table, so excel will treat it like text (what it is) when you paste it.

1. Highlight the text you want (all of it)
2. Open Notepad
3. Paste
4. Save (whatever.txt)
5. Open Excel
6. Open whatever.txt
7. Import the text using the "Fixed Width" feature to set your column.
8. Send Kristin cash or old bicycle seats instead of kudo's
that worked; thanks (good feature to know)DougSloan
Apr 29, 2003 12:40 PM
You saved my clients a lot of money on that one. I owe you.

So what bike seat do you want?

Thanks.

Doug
Any carbon fiber will do! ;-)Kristin
Apr 29, 2003 1:17 PM
No, no. I'm just trying to find a saddle I like these days...and my deriere wishes I'd hurry up at it! One thing that Licton's determined when they did my fit, was that I needed to get back--way back--which would require a different saddle. So far I've tried 3 saddles that friends have given me (usually stock ones that they didn't want themselves), but I've have had no luck yet. If you have any seats laying around that have long rails and you know you'll never use, I'll take one off your hands. (And I'll ship them back if they don't work out.)
Any carbon fiber will do! ;-)DougSloan
Apr 29, 2003 1:20 PM
I use those itty bitty SLR things. Probably won't help. You may need a setback seatpost (which I don't have, sorry).

Doug
I already tried a Ti FliteKristin
Apr 29, 2003 1:39 PM
That was a painful saddle. Perhaps I should check out a butterfly. I've been avoiding cushy looking saddles. My old one was very cushy, but it had really short rails and was really wide. Believe it or not, I already have a setback seatpost. I may need more setback, but I'm gonna try to get there with a saddle first.
another ideajose_Tex_mex
Apr 29, 2003 3:56 AM
If you want, you could leave both columns from the html page in the one excel column and cut out the bits you want.

Next, go over to B1 and type

=LEFT(A1,10)

Go to C1 and type

=RIGHT(A1,4)

Next,
1)highlight C1
2)hold down the shift key
3)press the left arrow button twice
4)press the "end" button
5)press the right arrow once
6)let go of shift key
7)press "alt", "e", "i", and "d"

The above just uses transition keys to make your moving around in Excel easier.