Fortunately, Excel has created TEXTBEFORE and TEXTAFTER to make these tasks much simpler. If you are interested in Excel’s text functions, you can also read the August 2023 Tech Q&A article “Join Text ...