A lot of my work lives in Excel (and Sheets), and for a long time, one repetitive chore took up more of my week than anything else: joining a handful of separate cells into a single piece of text.

If you're still typing long, comma-heavy CONCATENATE formulas to merge text in Excel, you're doing more manual work than necessary. Since switching to four alternatives that make combining data faster ...

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more. Working with strings in Microsoft Excel is common, whether you’re parsing, concatenating ...

Q. I have a long list of usernames that I need to make into email addresses by adding “@mtsu.edu” to the end of each username. Is there a simple way to do this, or will the ending have to be typed in ...