| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
separate text and digits within a cell
I have some data like this:
BTG400, ADTD2430, AE50 etc. I would like to separate the data in 2 columns with text in one column and number in another column. The max character for the text part is 4, and max of digit for the numberpart is also 4. Can someone help me please? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell with digits must be act like text | Excel Worksheet Functions | |||
| Sort by even and odd digits and copy to separate worksheet | Excel Worksheet Functions | |||
| separate text from one cell into 3 or more cells | Excel Discussion (Misc queries) | |||
| Separate text within a cell | Excel Discussion (Misc queries) | |||
| Trying to truncate or separate the first 3 characters/digits of co | Excel Discussion (Misc queries) | |||
Threaded Mode
