smreinholtz
New Member
- Joined
- Jul 10, 2014
- Messages
- 11
I looked around and cannot find a macro to cut the last character from a cell and put it into the next cell over. I would just use the text to column function but there are no common deliminators or text length.
For example:
<tbody>
</tbody>
Becomes:
<tbody>
</tbody>
Thanks in advance for any help!
For example:
9000600B | |
8475A | |
900655888A | |
741548C | |
300B |
<tbody>
</tbody>
Becomes:
9000600 | B |
8475 | A |
900655888 | A |
741548 | C |
300 | B |
<tbody>
</tbody>
Thanks in advance for any help!