Is there excel function or simple macro to determine if text is left or right in the cell?

I have a one column with many rows. Each row is containing text. Some text is aligned left, some in middle and some on right.

I would like to have a second column, where each row would receive a value: if the text is aligned on left, then "LEFT", if in middle then "MIDDLE" etc.

Any ideas how to do it?