Question: Suppose the manager wanted to change the item code so that the 4th character is changed to a K What formula would allow the manager

Suppose the manager wanted to change the item code so that the 4th character is changed to a "K" What formula would allow the manager to do this? (Ensure that the formula could be dragged down for all of column B) A2 "K")
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
