Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
making a number be text | Excel Worksheet Functions | |||
How do I convert a number formated as a date to text in Excel? | Excel Discussion (Misc queries) | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |