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:
[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD]9000600B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8475A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]900655888A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]741548C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]300B[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Becomes:
[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD]9000600[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]8475[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]900655888[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]741548[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD]B[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance for any help!
For example:
[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD]9000600B[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8475A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]900655888A[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]741548C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]300B[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Becomes:
[TABLE="class: grid, width: 300, align: left"]
<tbody>[TR]
[TD]9000600[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]8475[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]900655888[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]741548[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD]B[/TD]
[/TR]
</tbody>[/TABLE]
Thanks in advance for any help!