This post explains how to use the new Excel TEXTSPLIT function. TEXTSPLIT() is a Text function in Excel. The purpose of this function is to split a given text string on the basis of one or more ...

Find and Replace is a useful feature in the Office suite programs which allows replacing an existing text with a new text. However, it can also be used to find and replace the color of the text. You ...

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

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