Thread: Mask Account Number
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Mask Account Number
="XXX"&RIGHT(A1,4)
--
David Biddulph


"Need help" <Need wrote in message
...
I have a spreadsheet with tons of accounts numbers, and I need them to
show
up as 1234567 on my spreadsheet, but need them to show up XXX4567

how do I do this?


Reply With QuoteReply With Quote