deleting numbers in a column

R

roddtx

:) :) can someone assist with the formula that would allow me to remove
all but the last 4 digits in a column of numbers
 
G

Guest

Hi
You could use a helper column with this in:
=RIGHT(A2,4)
and fill this down.

Andy.
 
B

Bernard Liengme

Can we assume we are dealing with whole numbers?
=--RIGHT(A1,4)
RIGHT returns text, the double negation turns this back to a number

OR

=MOD(A1,10000)

Then copy either formula down the column.
 

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

Similar Threads

Delete all data after a symbol in a field 0
Autonumber field in Excel that behaves the same as Access 0
Macro to select and delete levels of a document 2
How can I remove the last 8 digits from every number 1
Delete a formula but leave the data. 2
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Removing Line Numbers 4
Excel does not accept text format! 0

Top