Hi All. So I have written some code that will split up the characters in a cell and paste them in adjacent cells. The last characters it pastes are some numbers. Sometimes though this number will contain one letter (from A-Z) at the end it. If this is the case I would like that letter to get pasted in the next cell adjacent to where the number will end up. Any thoughts would be appreciated.
I have the code working to do this:
82XX-103A Will get split up 82>X>X>103A (using ">" to illustrate next adjacent cell)
82XXX-103A Will get split up 82>X>X>X>103A
82XXXX-103A Will get split up 82>X>X>XX>103A
I would rather:
82XX-103A Will get split up 82>X>X>103>A
82XXX-103A Will get split up 82>X>X>X>103>A
82XXXX-103A Will get split up 82>X>X>XX>103>A
Working Code (I suspect their may be some unnecessary things it took a bit to get this far):
Please Login or Register to view this content.
Bookmarks