How to Separate Cell Values Using the Trim Function in Excel
In this exercise, we have values in cells that need to be divided and put into separate cells. For example, in cell Cell A1, we have Mail-man and we need to put both Mail and man into separate cells separated by “-”. To do this, we will use the TRIM, LEFT, MID and FIND Functions. [...]
Combine Cells with text, date, time and numbers in Excel
For this example, we are going to combine text and numbers from two different cells into one cell. To achieve this, we will need to use the & Operator. This will basically combine the different cell values that we will be working with. Here is how to do it.
How to combine text and numbers in [...]
