Credit Card# masking help

[aarjohn]

I work in the credit card industry and often need to provide large groups of merchant's batch data safely.

Can someone please assist with a formula that allows the first 6 and last 4 of a sixteen digit account number to be visible while replace then middle 6 numbers with "x". Once I have the formula, I can special paste the values and remove the original data.

(i.e.,original data 12345678123456789, end result = 123456xxxxxx6789)

Thank you in advance,
Aaron

 

[pagrender]

Try this:

=LEFT(A1,6)&"XXXX"&RIGHT(A1,4)

 

[VoG]

Try this

Excel Workbook
	A	B
1	12345678123456789	123456XXXXXX6789
Sheet1

 

[aarjohn]

worked great VoG. Thank you!