Oct 07 2019 02:05 PM
What is the formula for hiding the middle three digits in an account number with a dash? I have accounts that look like "ABC-123456". I am trying to put XXX in for the 3 digits in the middle. I want it to look like "ABC-XXX456"
Oct 07 2019 02:19 PM - edited Oct 07 2019 02:21 PM
using your example (abc-123456) you could use;
=replace(old text {the cell with the original act #}, start_num {how many units into the text you want to start replacing},num_chars {how many characters will be removed}, new text {what you want displayed})
all in all this is the formula to go from abc-123456 to abc-xxx456;
=replace(A1,5,3,"xxx")
Oct 07 2019 02:27 PM
Thank you, that worked. I was trying to link the function LEFT and RIGHT. It was just not working.
Thank you,
Brian.