Date and Time

Appending or prepending something is called concatenating in Excel. Concatenating is a big word for combining things in one cell. You could be trying to combine text and data, or two types of data, or two cells of text\data together into one cell. We'll be discussing how to concatenate text with date data. How to add text before or after a function in the same cell: Let's produce today's date in an cell. For that, we'll use the following function: =TODAY() Alone, this will produce … [Read more...] about Append or prepend text to the current date in MS Excel