software

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.

=RIGHT(TEXT(A1,quot;0quot;),LEN(TEXT(A1,quot;0quot;))-3)

--
Kind regards,

Niek Otten

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

Try something like
=MID(A1,4,LEN(A1)-3)

Andy.

quot;Jimquot; gt; wrote in message
...
gt;I have a spreadsheet with a column of numbers. I'm trying to extract /
gt; truncate / remove the leading 3 digits in each cell. The numbers vary in
gt; length, so using the LEFT or RIGHT function doesn't seem to be an option.
gt;
gt; The numbers represent division / dept. numbers within my company. The
gt; leading 3 digits represent the division, which I want to remove / discard.
Or if you want to retain decimals

=RIGHT(A2,LEN(A2)-3)

Regards
Peter Atherton
quot;Jimquot; wrote:

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

Thanks to all of you!

Niek - your formula worked for some of the entries, but for some cells the
result wasn't quite right. Example: returned last TWO digits on 7-digit
cells. I'm sure it would work with a slight tweak.

Andy - worked perfectly

Peter - worked perfectly.

quot;Jimquot; wrote:

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