How to split the data? office 2003
I have the excel data in the format “O##-alphanumeric character” in a single cell,
How can this be divided in to “O##” and “alphanumeric character”, then placed in separate cells
Example: - Data format “O26-Roughing-operation-3” in one cell,
Requirement “O26” and “roughing operation-3” in separate cells
I have the excel data in the format “O##-alphanumeric character” in a single cell,
How can this be divided in to “O##” and “alphanumeric character”, then placed in separate cells
Example: - Data format “O26-Roughing-operation-3” in one cell,
Requirement “O26” and “roughing operation-3” in separate cells