Hiding numbers within an account number

Copper Contributor

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"

2 Replies

@BMR01 

 

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")

@katrina bethea 

Thank you, that worked. I was trying to link the function LEFT and RIGHT. It was just not working. 

 

Thank you, 

Brian.