In the route log, E4/08:15/10:30 uses a slash after the route and another between the times. For a readable label, change the first separator and keep the time pair.

Choose occurrence 1

Put the original in A2. In B2 enter =SUBSTITUTE(A2,"/"," — ",1). The fourth argument targets the first slash. B2 should read E4 — 08:15/10:30.

Only the slash after E4 is replaced with a spaced em dash.

Illustrated text change. The slash between the times stays.

Check a single slash and a record without one

W2/14:00 becomes W2 — 14:00. T9 stays as it was. If a source inserts a slash before the route code, review that row because the formula counts occurrences in order. Keep the source field intact for imports and later checks.

W2/14:00 changes once and T9 stays the same.

Illustrated edge cases. Check records with fewer separators.

Microsoft’s SUBSTITUTE function reference