Excel: How to Split Word into Individual Letters

You can use the following formula in Excel to split a word into cells with individual letters:

=MID($A2, COLUMNS($A$2:A$2), 1)

This particular formula splits the word in cell A2 into separate cells that contain the individual letters of the word.

The following example shows how to use this formula in practice.

Example: Split Word into Individual Letters in Excel

Suppose we have the following list of basketball team names in Excel:

We can type the following formula into cell B2 to split the first team names into individual letters:

=MID($A2, COLUMNS($A$2:A$2), 1)

We can then click and drag this formula to the right until each letter has been accounted for:

We can then click and drag the formula down to the remaining rows to split each team name into individual letters:

Excel split word into letters

Each team name in column A has now been split out into individual letters.

How This Formula Works

Recall the formula we used to split a word into individual letters:

=MID($A2, COLUMNS($A$2:A$2), 1)

Here is how this formula works:

The COLUMNS function is used to count the number of columns in a particular range.

The MID function is used to extract a specific number of characters from a starting position in a string.

Thus, this formula extracts only the first character in column B and then only the second character in column C and then only the third character in column D and so on.

The end result is that each word is split into individual letters.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

Excel: How to Count If Cells Contain Text
Excel: How to Use COUNTIF with Multiple Ranges
Excel: How to Count Unique Values Based on Multiple Criteria

Leave a Reply

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