Posts by abaskhan_mkd

  • mid formula with vba

    hi,


    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

    and

    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.



    Thanks,

    ABAS