MacroRoni

Starter macros › Text & IDs

Mask account numbers

Keep only the last 4 characters of each value in column B and hide the rest with ****.

Changes data. A backup copy and an undo point are turned on.

What it does, step by step

  1. Keep the last 4 characters of B2:B1000
  2. Add “****” before B2:B1000

Use it in MacroRoni: open the Starter gallery, search for "Mask account numbers", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.

Get MacroRoni free

More text & ids macros

Text & IDsAdd leading zeros to IDsMake every ID in column A six characters long, like 000123, and keep the zeros.Changes data · backup onText & IDsFix ZIP codes that lost their zeroExcel drops the leading zero from ZIP codes like 02134. Put it back in column E.Changes data · backup onText & IDsGet the domain from emailsWrite the part after @ (the company domain) from column C into column D.Changes data · backup on