Thanks.. I did find another method from a co-worker..

A1 would have the root 20000, a2 would have =A1+.25 then b1 would
have ="TOTE"&int(a2)

It works.. have it drop off the decimal. copy/paste special.

a few extra steps but we got there.


Thanks for your help though