If you have a string of digits as individual characters, you would use the
Mid() function and here is a description of how to use it.
https://support.office.com/en-us/article/mid-function-427e6895-822c-44ee-b34a-564a28f2532c
If you have a numeric field (i.e. data type is NOT Short Text or Long Text) and you want to pluck the digits out of it in some manner, you might first convert the number to a string with
Stringvar = CStr(number), after which you would apply the
Mid() function anyway. Note that if this is all you want, I would use
Cstr() and not
Str() because
Str() includes a leading space for positive numbers.
If you were worried about a specific number of digits in the string, we would have to know more about the requirements, but in general that would involve using the
Format() function to make the string have that many characters.
Your answer will be somewhere in there, but (apologies) your question was too vague for me to clearly see what you wanted.