| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Splitting text in a cell
See if this can help.
Assume your A1 cell contains: SHEFFIELD UNITED:BLADES use formula in B1 =LEFT(A1,FIND(":",A1)-1) use this formula in C1 =RIGHT(A1,LEN(A1) - FIND(":",A1)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Splitting text in a cell | Excel Worksheet Functions | |||
| Splitting text in a cell | Excel Discussion (Misc queries) | |||
| splitting text from one cell | Excel Discussion (Misc queries) | |||
| splitting text in a cell.. | Excel Discussion (Misc queries) | |||
| Splitting Up Text in One Cell To Many | Excel Worksheet Functions | |||
Hybrid Mode
