Trying to truncate or separate the first 3 characters/digits of co


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.
 
Ad

Advertisements

Ad

Advertisements

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top