G
Guest
I have a spreadsheet with a column of numbers. I'm trying to extract /
truncate / remove the leading 3 digits in each cell. The numbers vary in
length, so using the LEFT or RIGHT function doesn't seem to be an option.
The numbers represent division / dept. numbers within my company. The
leading 3 digits represent the division, which I want to remove / discard.
truncate / remove the leading 3 digits in each cell. The numbers vary in
length, so using the LEFT or RIGHT function doesn't seem to be an option.
The numbers represent division / dept. numbers within my company. The
leading 3 digits represent the division, which I want to remove / discard.