| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text To Column
We have part numbers like this one "ACC0123". We are trying to seperate the
ACC and the 0123. However, when we do the text to column and fixed width, the "0" gets dropped. Have changed the field to be text, general, number and nothing seems to keep the "0". Any ideas? Thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
Threaded Mode
