Hi Experts,
I have account codes in column A, I want to separate them as follows, I am facing difficulty to apply formula to get in last column which is not fixed, please help
I have applied in Column B =LEFT(A1,4) and Column C =MID(A1,5,4) but need formula in Column D to get remaining of...