Is the suffix always exactly one character?

If yes:


=LEFT(A1,LEN(A1)-1)
--
Gary's Student


"BC" wrote:

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.