| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating Question
Raw Formated
HPQEI HPQ EI HPQBV HPQ BV DDMX DD MX EMCPE EMC PE I am trying to convert (reformat) ColA to ColB. The right 2 characters need to be separated from the other characters by a space AND the left characters need to have a length of 3. For example, for row 3 (DDMX), I need the formated value to be DD__MX. Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating Question | Excel Worksheet Functions | |||
| Worksheet formating question | Excel Discussion (Misc queries) | |||
| Formating question | Excel Discussion (Misc queries) | |||
| Formating Question Please | Excel Discussion (Misc queries) | |||
| Conditional Formating Question | Excel Discussion (Misc queries) | |||
Threaded Mode
