Thanks. Depending on what is needed there are a number of solutions to this kind of problem
BTW in the expression LEN(A2)*1 the multiplication is not necessary

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post