Hi.. I need to clean up data in a LASTNAME field.
I need to find and replace all the 'ii' and replace with 'II' and find all the 'iii' and replace with 'III'
The data looks like this
Need it look like this
Basically capitalize the '2nd' and '3rd'