i need to use MID formula with substitute function together for return result as below example.
in cell C1 have ( Frame:0/Slot:1/Port:4 ) this is in column B but after insert column it will be show in column C
cell A1 have ( LJRDHQI00_IBURV)
just i need to insert on column in B and use formula MID to return letter from A1 after put additional symbol (-) between
cell A return and cell C1 return.
Example: I-0/1/4 like this
if mid formula is not possible to solve then advise me which formula is good for this issue.