Move the character to the far right to another cell

[bobgrand]

Hello all,

I think I asked for help with this in the past but I can't seem to find anything in my history.

I need to take the last character in A1 and put it in B1. Can't use the MID function because the number of characters can vary.

	A	B
1	20A08D	D
2	PR115	5

<tbody>
</tbody>

Any help would be greatly appreciated.

Thank you
Bob

 

[wideboydixon]

=right(a1,1)

wbd

 

[bobgrand]

Excellent,

Thank you

Bob