>Is there more concise way of converting a memory variable from A15 to A14
>Here's what i have - seems a tad convoluted to me. Maybe i should just be grateful i got it on one line.
>
>n1="A15"
>n2="A"+LTRIM(STR(VAL(SUBSTR(n1,2,2))-1))
>
>tnx
>k
Don't know if you need this or not..........taking Borislav's solution and making it generic so that it isn't for just two characters
n2 = "A" + TRANSFORM(VAL(SUBSTR(n1,2)))