I have a field with a number 9 to 12 digit number.
the first two numbers and the last three numbers represent a store number and a sales ID.
I need a formula to break them up in three seperate fields for Store number (first two digits), Sales ID (last three digits),
and order number (middle digits between 4-8 digits).
Thanks!