Masking numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to remove or hide the first 5 digits in a string of 9 numbers for a
column. Any easy way to do this?
 
If you need it to be a number try
=value(right(A1,4))
if it can be text don't use the value()
 
Hello,

=--MID(A1,6,LEN(A1)-5)
to get result as a number

=MID(A1,6,LEN(A1)-5)
to get it as a string

If you are sure that it's a number and 9 digits you can take
=MOD(A1,10000)
or
=--RIGHT(A1,4)

HTH,
Bernd
 
You must log in or register to reply here.

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

How do I mask a Social Security Number ###-##-nnnn? 2
find and replace numeric strings in larger text strings 8
Validation of UK VAT Number 20
Sort Question 1
Match and delete rows on two different sheets from reference numbers 4
how to delete and insert in a two cells merge using Access 2003? 2
Sort column beginning with blank? 1
if statement for number of digits 5

Back
Top