Hello,
Im having an issue find a formula to help me add a prefix and suffix to a cell.
For example:
ALEX1000
for this cell I would like to add 2 random letters in front and 2 random letters in the back. I need it to look like something like this QXALEX1000BP
I found the formula (=left and =right) to remove it later, so I only need the random letters.
PS: It could be letters and numbers
Thanks and all help is appreciated.
Bookmarks