Reply to thread

Message: [QUOTE="Colin Hayes, post: 3869467"] Hi Ron Thanks for getting back. That fixed it - or nearly.. Where I have this content : 106366_7bx95 106319_7bx95 106208_12bx41 106239_12bx29 106241_12bx29 106258_12bx29 You formula correctly gives 106366 106319 106208 106239 106241 106258 Where I have C106271_12bx29 C106186_12bx29 C106285_12bx29 C106268_12bx29 C106231_12bx29 Your formula leaves it with a trailing underscore : 106271_ 106186_ 106285_ 106268_ 106231_ Is it possible to tweak it so that those starting with C no longer have the trailing underscore showing? (I did try changing the final -1 in the formula to -2. This did remove the final underscore for those beginning with C, but also removed the final number for those not starting with C , which of renders it useless.) Thanks again Ron [/QUOTE]