Hi
Sorry, I don't see de range 1-4 digits.
The array formula isFormula:
=RIGHT(MID(A1,SEARCH("RX",A1,1),COUNT(VALUE(IFERROR(MID(J9,{1,2,3,4},1),"")))+2),COUNT(VALUE(IFERROR(MID(J9,{1,2,3,4},1),""))))
Regards
Hi
Sorry, I don't see de range 1-4 digits.
The array formula isFormula:
=RIGHT(MID(A1,SEARCH("RX",A1,1),COUNT(VALUE(IFERROR(MID(J9,{1,2,3,4},1),"")))+2),COUNT(VALUE(IFERROR(MID(J9,{1,2,3,4},1),""))))
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks