Hi all, I'm trying to create a customer database. I got some great help the other day and I'm hoping that someone might be able to help me with a second piece of the puzzle. I was able to create a formula to take the first 5 letters from a customer name and add 4 digits to the end (eg: ALLST0001).
My problem now is that I ended up with 4 accounts with that exact same company acct code. Is there any way to specify to only use "1" once? So that it would show like so:
ALLST0001
ALLST0002
ALLST0003
ALLST0004
ALLCI0001
My problem now is that I ended up with 4 accounts with that exact same company acct code. Is there any way to specify to only use "1" once? So that it would show like so:
ALLST0001
ALLST0002
ALLST0003
ALLST0004
ALLCI0001