MS Excel: How to apply multiple alignments in a single cell

Question

I'm creating a printable sheet using Excel. I'm using the row-column structure to make a very neat and ordered sheet.

I'm trying to set different alignments for different parts of a cell, like so:

T1234,              TA1234,               TCA1234,
ST1234,            STA1234,              STCA1234,

I know that I can split those into 3 cells, but that screws with the formatting of the rest of the sheet, requiring me to do a lot of unnecessary horizontal merges, which itself lends to complications in formatting.

I know that in MS Word there is an option to set different alignments on different parts of a line. Is there a similar formatting option in Excel?

Answer 1

I do believe this is what you are looking for.

Earlier:

Now apply,,

• Format cells , Alignment, Text alignment.
• Apply Distributed Indent for Horizontal and Distributed for Vertical.

After:

N.B.

• It aligns the first word to the Left, Middle to second, and Right alignment to the last word in the cell.

Answer 2

Using the format in the answer provided... there's an interesting effect if you in-cell format pieces of the text differently. For example, making the third "B" of "BBBB78" red instead of black. Been around quite a long while, but no one talks about it and no one fixes it.