RIGHT function used relative

  • Thread starter Thread starter Bonnie
  • Start date Start date
B

Bonnie

Is it possible to make the "A1" in RIGHT(A1,4) relative?

I am using a Word mail merge with an Excel file to create
a receipt where I only print the last 4 digits of a credit
card number, where my criteria is that the field "How"
= "cc" from in Excel file.

Any suggestions?
 
Hi,

in this formula the "A1" is relative. =Right(A1,4)
absolute would be =Right($A$1,4)

John
 
Back
Top