Excel Question

Posted By: Princess of Power

Excel Question - 12/18/13 05:01 PM

Admit that I am stumpped and not sure if or how to do the following. Is there a way to take a 16 (or any size) digit number and have ONLY the last 4 digits appear?

Thank You
Posted By: Doug Hendrickson

Re: Excel Question - 12/18/13 05:18 PM

If all you want is the last four digits, you could use a formula such as =RIGHT(A1,4) which would only place the last four digits into the cell in which you have the formula, as shown below.

1234567890123450 3450
Posted By: Princess of Power

Re: Excel Question - 12/18/13 05:35 PM

Thank You - You made my day!!
Posted By: basilring

Re: Excel Question - 12/18/13 10:01 PM

I like that tip too. Awesome!