Question: 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)

```

Answer: 
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](https://support.office.com/en-us/article/concatenate-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d)
Try,

```
=LEFT(REPLACE(REPLACE(A17, 1, 12, TEXT(,)), 2, 0, CHAR(58)), 5)

```

This doesn't use ampersands or quoted strings.