| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Splitting an Excel cell
I am trying to figure out to split a cell formated with a numeric and alpha
format. For example, the format is "10100 Accounts Payable" I want to split the cells to "10100" (1st cell) then "Accounts Payable" (2nd cell). I have 2,700 cells to split, so I need efficient commands. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell on one page equals cell on another page in excel? | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
| Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Threaded Mode
