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.

[TABLE="class: grid, width: 200, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]20A08D[/TD]
[TD]D
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]PR115[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]






Any help would be greatly appreciated.

Thank you
Bob

 

[wideboydixon]

=right(a1,1)

wbd

 

[bobgrand]

Excellent,

Thank you

Bob