You can use VLOOKUP or HLOOKUP to find corresponding information in a list of data, either vertically (VLOOKUP) or horizontally (HLOOKUP).
The VLOOKUP function scans vertically down the leftmost column of data, looking for a match to the input you provide. Upon finding a match, VLOOKUP returns a value from the given row, corresponding to a [...]

Excel gives you the ability to combine text from multiple cells into a single destination cell.
For example, if you have a cell that contains a first name and another cell that contains a last name, you can combine those cells together and also include arbitrary strings of characters such as a spaces (“ ”), or [...]

In Excel, you can take a cell and split its text across columns in a number of ways. The easiest of these is to use the Text to Columns command under the Data menu in Excel.
For example, if you have a cell that contain both first and last names, you can use the Text to [...]

Occasionally, you may need to use a formula to change the way data appears. And, it is often handy to be able to extract the resulting value of a formula, but not the formula itself.
For example, you can use a formula to remove extra spaces from data. If you then wanted to split the [...]

If you have data that contains additional spaces, there is a function you can use to trim them out.

Select a destination cell for your formula.
Type =trim([cell name]), then press Enter.

Note: According to Excel’s Insert Function dialog box, “Trim removes all spaces from a text string except for a single space between words.”