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.

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.

Illustrated edge cases. Check records with fewer separators.



