| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert characters into String
Hi
I have string, eg. TH00000000789F in a range, let say in column A, how do I insert "-" after the first 2 characters and before the last character resulting TH-00000000789-F. The string are always 12 Characters. Thanks in advance regards, francis |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cut the last 20 characters out of a text string | Excel Discussion (Misc queries) | |||
| Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
| Remove characters from string | Excel Programming | |||
| use macro to insert characters at the beginning of a string | Excel Programming | |||
| Insert characters in a text string | Excel Worksheet Functions | |||
Threaded Mode
