|
SBR High Roller
Join Date: 04-17-07
Posts: 132
|
This will take some work, but you can do this using four programs:
Your browser
Notepad
MS Works
Excel
Click on reply to any tread on the SBR board
When you paste the data into the reply box of the SBR board and then click on "preview post"
S.09*,,Tenn,,,,,,,,,,,,,,W,,,,+20,,30-31,o47
becomes
S.09* Tenn W +20 30-31 o47
Copy all that data into Notepad.
Go down the list and erase any spaces you find in names you want in one cell, for example change
NEW MEX.
into
NEWMEX.
Click on CTRL+H or on Replace under Edit
In the top field (Replace what) just put one space, nothing else
In the bottom field (Replace with) put a comma
On the right, select Replace All
So
S.09* Tenn W +20 30-31 o47
becomes
S.09*,Tenn,W,+20,30-31,o47
Now do the same replacing every "-" with a "," (don't use the quotation marks), so
S.09*,Tenn,W,+20,30-31,o47
becomes
S.09*,Tenn,W,+20,30,31,o47
You can do a whole block of data at once, I'm just using one example.
Now copy all this and paste it into an Microsoft Works Spreadsheet.
You will see that every comma makes the data behind it go into a new cell, so
S.09*,Tenn,W,+20,30,31,o47
becomes
S.09* l Tenn l W l +20 l 30 l 31 l o47
Now you can paste all that into your excel sheet.
|