Display only last 4 character in Google Sheets
Current situation: I have a scanner which will scan customer id. The id number will be in google sheet. However, on scanning I do not want google sheet to extract the whole ID. But just the last 4 character.
This is due to privacy issue.
Eg: Customer id is :y656547i google sheet will only have : ****547i
I know how to use replace formula. but with replace formula i still have the id in google sheet.