If you're working in Excel and need a quick way to generate a custom identifier using a person's first name followed by a random number, this formula is a perfect solution.
🎯 What the Formula Does
=IF(ISNUMBER(SEARCH(" ", B2)), TEXTBEFORE(B2, " "),...