View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dvinechild Dvinechild is offline
external usenet poster
 
Posts: 17
Default Reverse Concatenate?

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.