Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello All,
I'm looking to seperate out a list of alpha-numeric codes into seperate columns. sound too easy? Here's the catch: Examples: A01 (single aplha, 2-digit num) = A - 01 A01a (single aplha, 2-digit num, sub-alpha) = A - 01 - a AA01 (2-alpha, 2-digit num) = AA - 01 AA01a (2-aplha, 2-digit num, sub-alpha) = AA - 01 - a If anyone knows how to get this to split up correctly, unfortunately I have to do it for pretty much the entire alphabet and up to about 38-65 numerically. :-) Please advise or lead me in the rigth direction. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
reverse value | Excel Worksheet Functions | |||
Reverse concatenate | Excel Discussion (Misc queries) | |||
Reverse Concatenate | Excel Worksheet Functions | |||
reverse of concatenate | Excel Discussion (Misc queries) | |||
I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel |