| View previous topic :: View next topic |
| Author |
Message |
westclean
General User
Joined: 18 Apr 2012
Posts: 6
Location: United States
|
 Posted: Mon Apr 23, 2012 12:18 pm Post subject: [Solved]Truncating the proceeding numbers |
 |
|
Can anyone tell me a simple way to truncate the proceeding numbers. For example I have a credit card number 123456789 stored in sheet1, but want to record it on sheet2 by just its last 4 digits 6789. The function TRUNC() works well if I want to change 3.14159 to 3.14 but is no use for this.
Last edited by westclean on Mon Apr 23, 2012 12:32 pm; edited 1 time in total |
|
| Back to top |
|
 |
UmTheMuse
General User
Joined: 05 Apr 2012
Posts: 33
Location: United States
|
| Posted: Mon Apr 23, 2012 12:28 pm Post subject: |
|
|
| use the RIGHT() function (no pun intended). ="*****" & RIGHT(A3,4) except you'll replace A3 with whatever your reference is. |
|
| Back to top |
|
|
westclean
General User
Joined: 18 Apr 2012
Posts: 6
Location: United States
|
| Posted: Mon Apr 23, 2012 12:33 pm Post subject: |
|
|
| Thank you, I knew there was a function for it. |
|
| Back to top |
|
|
|
