Friday, March 4, 2016

i need formula to show only last four digits of bank account number

i need formula to show only last four digits of bank account number

i need formula to show only last four digits of bank account number
 
for e.g., i have a list of bank account numbers and i need only the last 4 digits to be visible rest should be asterisk
 
123456 should become **3456
7894316874621 should become *********4621
etc.

Keys to the Problem i need formula to show only last four digits of bank account number

Download Error Fixer (Free)

Hi,
 
With the number in a1 use this, drag down as required.
 
=REPT("*",LEN(A1)-4)&RIGHT(A1,4)

To install drivers and other optional updates

  1. To install optional updates, you need to review and then select them from the list of updates that Windows finds for your computer. Optional updates are not installed automatically.
  2. Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
  3. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
  4. If any updates are found, click View available updates.
  5. Select the optional updates that you want, and then click Install. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

Recommended Method to Fix the Problem: i need formula to show only last four digits of bank account number:

 

 

How to Fix i need formula to show only last four digits of bank account number with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your computer. When you open it, it will perform a scan.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.


Related: Avtask Exe cleanmgr exeCwbckver exe Exe Has Stopped Working In Vista Dfbhd Setup Exe toaster exe Hdashcut exe stikynot exe Hpqgalry exe Isass Exe Entry Point Not Found Ikernel exe Launched Class Is Not Registered ccp exe file has stopped working 2015 Mci Info Exe Entry Point Not Found Data Execution Protection psexec exe Java exe Setup Exe Might Have Moved Deleted 7z465 exe What To Do For Mcshield exe High Cpu Usage Dumprep Exe It xcopy exe Dplaysvr exe What Exe Is This,Backup On Windows 7.1 64 Bit Fails Because It Says No Enabled Devices (0x80070422),Ofiice 2007 On Window 7: Any Faster Way Of Attaching A Working File To Reply On E-mail ?,Where To Store TS Files For Each User On A Windows 2008 Terminal Server,Why Window Explorer Is Stopped Working Is Pop Up While I Restart Or Shutdown Everytime?,Excel 2007 Web Query Reports That A Connection Was Established But Data Is Not Available.
Read More: Solution to Error: Error code 200836B3 while installing Wind,Spreadsheet for Arabic Layout,Windows 7 64 momentarily freezing when opening/closing minimizing and switching between open programs.,wmp icon associated with mp3 missing,word shuts down and restarts when adding citations,Interesting behavior with text formatted cells,How do I add pictures to the Start screen?

No comments:

Post a Comment