bobgrand
Board Regular
- Joined
- Apr 14, 2008
- Messages
- 244
- Office Version
- 365
- Platform
- Windows
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.
<tbody>
</tbody>
Any help would be greatly appreciated.
Thank you
Bob
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