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 ...

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.

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 ...