Reverse Concatenate?
On Sep 29, 2:20*pm, Dvinechild
wrote:
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.
this is how I did it. I am sure there has to be something much easier
then this, but it shoudl do the trick to the above guidleines.
Thanks,
Jay
=IF(LEN(K1)=3,LEFT(K1,1)&" - "&RIGHT(K1,2),IF(LEN(K1)=5,LEFT(K1,2)&" -
"&RIGHT(LEFT(K1,4),2)&" - "&RIGHT(K1,1),IF(ISNUMBER(-
RIGHT(K1,1)),LEFT(K1,2)&" - "&RIGHT(K1,2),LEFT(K1,1)&" -
"&RIGHT(LEFT(K1,3),2)&" - "&RIGHT(K1,1))))
|