How to remove a suffix in excel
 

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.

How to remove a suffix in excel
 

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.

How to remove a suffix in excel
 

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

"Gary''s Student" wrote:

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.

How to remove a suffix in excel
 

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

"BC" wrote:

Community Message Not Available