Excel question (50 points for best answer)

[Justin7]

In a single column, I have a field that has 3 fields:
"O", "U" or "P" (indicating if a game went over or under the game total, or pushed)
x - a number (game total - 7, 7.5, ... as high as 12.5)
ml price (-120, +109, ... depedending on whether that total is a fav or dog)

An example entry of this column is
U 8 -109

How do I pull the middle entry (8 in this example) out of that column?

[Brock Landers]

i suck at excel, always ask others for a hand at work LOL

[pat venditto]

Justin you're a rookie son.

[ZetaPsi808]

1. highlight the entry or column u want to delete
2. right click the highlighted area
3. drop down menu will appear, click delete.
4. another menu will appear, click shift cells left, or whatever option works best for you

i hope this works justin

[Justin7]

Tomcowley showed me how to do it
Here is his solution:
make sure next 2 columns are blank
select column, data, text-to-columns
pick space as a delimiter
done

[jjgold]

Justin forget all that shit

Best way to make money betting sports is scalping/middling

there is no other way

[Brock Landers]

Justin forget all that shit Best way to make money betting sports is scalping/middling there is no other way

87% winners makes a lot of cash for people

[Scorpion]

Tomcowley showed me how to do it
Here is his solution:
make sure next 2 columns are blank
select column, data, text-to-columns
pick space as a delimiter
done

yes, thats how you do it
excel and dbase are good tools for making data base files

[Patrick McIrish]

Very handy information for those not aware.

[Tinytimmy]

poor workaround. best way to get the correct info out is the MID function (or LEFT or RIGHT if you need it)
e.g. to get the '8' out you'd use MID(cellreference,2,2)

[mtneer1212]

Tinytimmy just echoed my proposed solution.