how do i show only the last four digits of a credit card number

[Guest]

how do i show only the last four digits of a credit card number

 

[Guest]

=Right(A1,4) will show last 4 digits/characters of number/text in A1

 

[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

 

[Don Guillett]

=right(a2,4)

 

[Bearacade]

if your Credit Card number is in A1, you can use Right(A1,4)

 

[Bearacade]

You can also try this:

=CONCATENATE(REPT("XXXX-",3), RIGHT(B3,4))