Search code examples
excelformula

How to nest MID function in excel?

Im trying to nest multiple MID functions in one formula. Here is what i got, at the same time im trying to add some text in between &":" them i want another mid function. But not working, any ideas?

=MID(A17,13,1)&":"MID(A17,14,3)
Solution

  • You can use the CONCATENATE function:

    =CONCATENATE(MID(A17,13,1),":",MID(A17,14,3))

    So you can concatenate multiple conditions using the separator (, for English).

    Reference: concatenate-function