If you use the text to column, you could then use =right(A1,2) to get
A1 B1
New England 30 30
"Jambruins" wrote:
Cell A1 = New England 30, Oakland 20.
Is it possible to have the following:
cell B1 = New England
cell C1 = 30
cell D1 = Oakland
cell E1 = 20
Cells A2-A16 are similar but the team name and number changes and the team
names are all different lengths.
If that won't work I could use text to columns and split it at the , so cell
A1 = New England 30 and cell B1 = Oakland 20. But I would still want the
team name and score to be separated. Using the above method would save me
from having to use the text to columns command.
Thanks
|