Partial result
Hello,
I'm attempting to create a way to review an account number from one cell, and have a different cell populate just the last four digits with X's for any other remaining characters. So account 1234567 would show XXX4567, where as account 123456789 would show XXXXX6789. Fairly new to complex formulas and not sure where to start with this.
Best Answer

=RIGHT("XXXXXXXXXXXXXXXXXXXXXXX" + RIGHT(account@row, 4), LEN(account@row))
This assumes max account length of 18 digits. If you have longer numbers, add more Xs!
EDIT to add:
This formula will end with a result that is the same length as the original account number. If you want to fix the length, replace the "LEN(account@row)" at the end with whatever length you want, eg 10.
Answers

=RIGHT("XXXXXXXXXXXXXXXXXXXXXXX" + RIGHT(account@row, 4), LEN(account@row))
This assumes max account length of 18 digits. If you have longer numbers, add more Xs!
EDIT to add:
This formula will end with a result that is the same length as the original account number. If you want to fix the length, replace the "LEN(account@row)" at the end with whatever length you want, eg 10.

That worked like a charm! Thank you
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!