Excel - strip leading spaces?

Factual Questions
1

I’m trying to prepare some data exported from an ancient (errm, 1991) DOS system ready for an import into another database. I’ve got it into an Excel sheet, but many cells have acquired a single space at their beginning, before any text beings. Is there a simple way to clear out all of these superfluous spaces?

2

You can use the TRIM command to remove any leading and trailing spaces from a cell

=TRIM(A1)

Which will turn

My Text Here

into

My Text Here

3

(Except of course, the first “My Text Here” has a leading space that doesn’t show up."

" My text here" into “My Text Here”