Skip to content
Home » Transforming Your Data: Excel’s Top Text Formulas

Transforming Your Data: Excel’s Top Text Formulas

CONCATENATE Formula

The CONCATENATE formula is used to combine text from multiple cells into one cell.

=CONCATENATE(A1," is the best website")

This formula would combine the text in cell A1 with the text ” is the best website”.

Excel Formula Concatenate Example

LEFT and RIGHT Formula

The LEFT and RIGHT formulas are used to extract a specified number of characters from the left or right side of a cell, respectively.

=LEFT(A1,5)

This formula would extract the first 5 characters from the left side of the text in cell A1.

Excel Formula LEFT Example
=MID(A1,3,5)

This formula would extract 5 characters from the middle of the text in cell A1, starting from the 3rd character.

Excel Formula MID Example

PROPER Formula

The PROPER formula is used to capitalize the first letter of each word in a cell.

=PROPER(A1)

This formula would capitalize the first letter of each word in the text in cell A1.

Excel Formula PROPER Example

Leave a Reply

Your email address will not be published. Required fields are marked *

four − one =