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

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

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

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

"ExcelB" wrote:

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

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

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



"ExcelB" wrote in message
...
how do i show only the last four digits of a credit card number

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

=right(a2,4)

--
Don Guillett
SalesAid Software

"ExcelB" wrote in message
...
how do i show only the last four digits of a credit card number

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

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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=552847

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

You can also try this:

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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=552847