Create an additional column at the end called "New Order Number" that uses a formula to add a region code at the front of each order number.Order Number $-$ Create an additional column at the end called "New Order Number" that uses a formula to add a region code at the front of each order number. The

region codes are: East $=101.$ South $=201.$ Central $=301.$ For example, the order number, $"496-1850"$ from Central would look like $"301-496-1850".$ The region codes

might change so set them up as input cells that can be altered in the future. Consider using named ranges.