Update the output cells so that each row displays a new code which should be equivalent to the old code but with the middle segment of the text replaced with the region. The middle segment is the text between the first and second hyphen. See Examples
Your solution should use cell references so it updates automatically if the input cells change values.
This cell cannot be edited
Update the output cells so that each row displays a new code which should be equivalent to the old code but with the middle segment of the text replaced with the region. The middle segment is the text between the first and second hyphen.