| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seperating text within a cell
I downloaded a QuickBooks file into excel. One of the cells includes the
account number (4 digit charachter) a dot (spacer) and then the account name. I can I break out the account number from the account name? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Seperating text within a cell
Hello,
You can goto Tools | Text to Columns when the wizard appears, choose delimmited by period. HTH Roger "Alan" wrote: I downloaded a QuickBooks file into excel. One of the cells includes the account number (4 digit charachter) a dot (spacer) and then the account name. I can I break out the account number from the account name? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Parsing / seperating text string in excel cell | Excel Discussion (Misc queries) | |||
| seperating values from text | Excel Discussion (Misc queries) | |||
| Seperating text | Excel Discussion (Misc queries) | |||
| seperating text in one cell to multiple cells | Excel Discussion (Misc queries) | |||
| Seperating of Text in one cell into two columns | Excel Worksheet Functions | |||
Linear Mode
