Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi--
I have a string that is a unique ID number in the form XXX-XXX-XXX. However, the number of digits in each segment of the string varies. For example, all of the following are valid: 2-5895-223 1213-23-257676 55-1-2 I am trying to write a formula to split the string into three separate numbers. Using the first example, the three numbers would be: 2 5895 223 I am having trouble writing a formula flexible enough to identify where the dash is and to split the string in the right place. Any suggestions? Thanks, Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
String splitting for inconsistent strings | Excel Worksheet Functions | |||
Splitting a concatenated string into separate rows... | Excel Worksheet Functions | |||
Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
Inserting a string seach within a complex function | Excel Worksheet Functions | |||
Splitting Character String | Excel Worksheet Functions |