I would like to move the last word in a text string in a singe cell to the cell on its right (for all cells in the colunm). The text list could be:
James Brown T-3250
Jackie Chan Hero T-3200
Mary T-3333
In this list I want the last word (i.e. the T-something) cut and pasted to the column on the right, leaving the rest of the words intact.
Thanks.
Solved: Stanley's code was very clean and nice. Thanks all.
Bookmarks