|Posted: April 13, 2005, 10:53 pm - IP Logged|
|Cash 3||5/1/2004||8, 7, 7|
|Cash 3||5/2/2004||6, 5, 0|
|Cash 3||5/3/2004||7, 4, 2|
|Cash 3||5/4/2004||2, 4, 3|
|Cash 3||5/5/2004||9, 4, 4|
|Cash 3||5/6/2004||2, 7, 3|
|Cash 3||5/7/2004||9, 6, 4|
|Cash 3||5/8/2004||8, 4, 1|
|Cash 3||5/9/2004||4, 4, 5|
|Cash 3||5/10/2004||3, 5, 9|
I am trying to import previous lottery results into an excel spreadsheet.
The above is how it looks--Just wondering if there is any way that I can get rid of the , so that I can just cut and paste results into the specific area that I want.
If your 3 digit numbers are in one column you can select the entire column.
Go to you Menu bar and choose > Data > Text to Columns > Delimited > Select Coma (make sure all the other Delimiters are unchecked> Click Finish
Each number will be in their own individual column.
If you want to put all three digits in 1 cell use the following formula:
This is if Position 1 is in cell A1, Position 2 is in cell B1, and Position 3 is in cell C1.
This formula below would go in cell D1
Hope this helps!!