RIGHT function used relative

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?
 
J

John

Hi,

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

John
 
Top