Glad to be of help.


If the length of the number string may vary then the code could be changed to include the inbuilt Mid() function and the inbuilt IsNumeric() function, to find the position of the first numeric value in the field. I did consider this as a solution but as the supplied data all had the same length of numeric values, the solution offered was the easiest. If you need help with a more complex solution please post back.