how do i truncate first few characters in column of numbers
Posted by Dwight Hamilton on March 08, 2001 6:36 AM
I want to erase the first 3 digits in a long column of 13 digit numbers. First three digits are all the same (069; numbers vary thereafter. Don't want to use find/replace because 069 appears again in some of the numbers. Don't care whether the final result is "text" or "number". Thought that the text function "Right" might be the answer, but couldn't get it to work since all of the numbers are different, other than the leading 3 digits.