I have many cells in an Excel sheet, using 9 characters of 0-9 and A-Z, that have some number of prefixed zeros:
000000123 000001DA2 0000009Q5 0000L210A 0000014A0 0000A5500 00K002200
I'd like to remove the leading zeros so that the values become:
123 1DA2 9Q5 L210A 14A0 A5500 K002200
How would I do this in an Excel formula? I'd prefer to avoid use of a VBA macro.