Mask Account Number

  • Thread starter Thread starter Need help
  • Start date Start date
N

Need help

I have a spreadsheet with tons of accounts numbers, and I need them to show
up as 1234567 on my spreadsheet, but need them to show up XXX4567

how do I do this?
 
you can use the concatenate and the mid() function

if your account number is in cell A1 and is say 10 characters long

use mid(a1,4,6) this will give you the last 6 numbers then just
concatenate it to the XXXXs

"XXXX"&mid(a1,4,6)
 
Hi,

One way. Say these numbers are in column A starting in A2. Put this in B2

="XXXX"&RIGHT(A2,4)

Drag down as required and then hide column A

You could even have the numbers on another sheet and use the formula

="XXXX"&RIGHT(Sheet2!A2,4)

You could then hide the entire worksheet with the numbers on.


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top