Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results. When concatenating—using a formula ...

In Microsoft Excel, Concatenate is a text function, and its purpose is to combine two are more text strings into one string. The Concentrate function can improve the way your data is aligned in your ...

The concatenate function may not be as well known as other common Excel features such as IF and VLOOKUP, but it’s still effective, even though it performs a more simple function in nature. If you are ...

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

You can add text to a cell in Microsoft Excel the traditional way by simply typing, but there are other ways to get the job done. For example, you can use a formula, or even a function to accomplish ...

You know how Excel is mostly really good but weirdly weak in a few areas? Mark Gibbs has found a fix for one issue: String concatenation. And while he’s on the subject of data manipulation he begins ...

When you enter longer text than will fit in a normal Excel cell, the excess text either carries over into the next blank cell or is truncated by adjacent data. You have several options to remedy this.

Sometimes it's not possible to separate data yourself before putting it into an Excel spreadsheet. Often, the information from old data files gets lumped into a single cell. The same can happen if you ...