Number/Digit Replacement

  • Thread starter Thread starter Scottie
  • Start date Start date
S

Scottie

Have numbers in column "3220", "3450", etc. Want to drop
third digit from right by one number, such as from "3220"
to "3120". What would be the code in an XLS function for
this?
 
Hi Scottie

do you mean you want to subtract 100 from each number?

then
=A1-100
where your original number is in A1
copy this down the column to get all of your numbers.

Cheers
JulieD
 
Hi Scottie
maybe I'm missing something but why don't you use
=A1-100
and copy down

After this you may copy this helper column and insert this as 'Values'
(goto 'Edit - Paste Special')
 
Scottie

If they are numbers (and not text): Type 100 in an unused cell. Copy it and
then select your range. Edit / Paste Special / Subtract.

Andy.
 
Back
Top