Originally Posted by Jayjones

The data can be various lengths but it's always the last 4 characters but one that needs to be replaced ie I want excel to count from right 5 characters then replace the next 4 characters leaving the 5 th character intact