I'm using this formula =IF(LEFT(A1,3)="The",RIGHT(A1,(LEN(A1)-4))&" (The)",A1) to convert any string starting with 'The' as follows:
The Long and Winding Road
Tired Feet
The Highest Mountain
to
Long and Winding Road (The)
Tired Feet
Highest Mountain (The)
I want to be able to convert this into a macro, but I'm not sure how to go about doing that.
Can anyone help, my knowldge of VBA is extremely limited.
Bookmarks