E
ExcelB
how do i show only the last four digits of a credit card number
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Toppers
=Right(A1,4) will show last 4 digits/characters of number/text in A1
C
Chip Pearson
If the number is in cell A1, use the formula
=RIGHT(A1,4)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
=RIGHT(A1,4)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
D
Don Guillett
=right(a2,4)
B
Bearacade
if your Credit Card number is in A1, you can use Right(A1,4)
B
Bearacade
You can also try this:
=CONCATENATE(REPT("XXXX-",3), RIGHT(B3,4))
=CONCATENATE(REPT("XXXX-",3), RIGHT(B3,4))