How do you break down a word by its letters in excel?

Use the LEN function. It will count the amount of characters in a cell or in a literal piece of text.

To count the amount of text in cell A3, put this formula into another cell:

=Len(A3)

The following will give you 11 as there are eleven characters, including the space in the piece of text:

=LEN("Hello World")