Formula To Remove Last Letter Of Data In Column C To Column D

[Dazzawm]

I have data starting in C2 like below of various lengths and I would like a formula to remove the last letter to column D please

ANMIN13 2015A
ANMIN13 2015B

Result In C

ANMIN13 2015
ANMIN13 2015

Result In D

A
B

 

[Kaper]

With the formula you will not put the results in the same place (column C) as source data.
So let's produce results in columns D and E.
If your data starts in C2 then
in D2:

=left(C2,len(C2)-1)

and in E2

=right(C2,1)

Edit: After publishing I noted that it is yours 3000+ post. The question seens to be too basic for such experienced user. So may be there is some catch?

 

[Dazzawm]

With the formula you will not put the results in the same place (column C) as source data.
So let's produce results in columns D and E.
If your data starts in C2 then
in D2:

=left(C2,len(C2)-1)

and in E2

=right(C2,1)

Edit: After publishing I noted that it is yours 3000+ post. The question seens to be too basic for such experienced user. So may be there is some catch?

No I just use it all for work and don't have the time to learn it all.

 

[Kaper]

So it means you have "free subcontractors" here :-/.

Not_learning_just_using approach hurts me as a lecturer (since mid '90ties).

Anyway, if it worked, consider marking the solution: Mark as Solution

 

[Dazzawm]

So it means you have "free subcontractors" here :-/.

Not_learning_just_using approach hurts me as a lecturer (since mid '90ties).

Anyway, if it worked, consider marking the solution: Mark as Solution

Correct me if I am wrong but I thought this was a free forum and up to those that want to help?