View Single Post
Old 08-07-2007, 12:06 AM   #8 (permalink)
Breaker
SBR High Roller
 
Breaker's Avatar
 
Join Date: 04-17-07
Posts: 132
Breaker is offline
Default

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.
Reply With Quote