I have a bunch of cells within a column and need to move the word "TRUST" to it's appropriate location within it's cell.
Example:
BARNES LENNY R TRUST: Should be LENNY R BARNES TRUST
CRAMER LIVING TRUST: this is correct
HOPPER FAMILY TRUST: this is correct
LEVENSON A E & F F TRUST: Should be A E & F F LEVENSON TRUST
MORRIS RANDALL D TRUST: Should be RANDALL D MORRIS TRUST
FERGUSON JACQUELYN K TRUST: Should be JACQUELYN K FERGUSON TRUST
MONTALBANO FAMILY TRUST
Is there a way to do this? I have thousands to correct.
Any help is greatly appreciated
Bookmarks