Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel: The cell value is MSGF105, I need to format it to read GF105 1
- Thread starter coolcarls
- Start date
-
1
- #2
SkipVought
Programmer
Carl,
Use Data/Text to Columns, fixed width - select a divider to parse 2 characters, in the column data format option select [/b]Do not import column (skip)[/b]
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
Use Data/Text to Columns, fixed width - select a divider to parse 2 characters, in the column data format option select [/b]Do not import column (skip)[/b]
Skip,
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question