How to remove a suffix in excel

[BC]

type I have the following example data in cells and need to separate the
suffix.
Adelphi Blue7
The suffix may be alpha or numerical but in all cases there is no space
between the main text and the suffix.

 

[Gary''s Student]

Is the suffix always exactly one character?

If yes:


=LEFT(A1,LEN(A1)-1)

 

[BC]

No, sometimes it's two but never more than that.

Is the suffix always exactly one character?

If yes:


=LEFT(A1,LEN(A1)-1)

 

[BC]

and I also need to use the suffix i.e. put Adelphi Blue in one cell/column
and the suffix in another