I have a large set of data that contains SKUs with different number of characters. Each SKU can range from 10-20 characters. The only thing that is constant is the last 4 characters. Which formula can i use to only replace the 4th character from the right?
Example
SKU1-U-101
SKUUU-U-101
replace "U" with "A"
Results
SKU1-A-101
SKUUU-A-101
Thanks in advance!
Example
SKU1-U-101
SKUUU-U-101
replace "U" with "A"
Results
SKU1-A-101
SKUUU-A-101
Thanks in advance!