Leading and Trailing Zero in Excel

DrExcel_Excel_MVP 

Hi.  There are similarities.

My formula came out as

= MAP(list, TrimZeroλ)

where TrimZeroλ is given by

= LET(
    nonzero, Explodeλ(text) <> "0",
    first,   XMATCH(TRUE, nonzero),
    last,    XMATCH(TRUE, nonzero, , -1),
    MID(text, first, 1 + last - first)
  )

Explodeλ is pretty standard

= LET(
    n, LEN(text), 
    k, SEQUENCE(n), 
    MID(text, k, 1)
  )