I exported data that automatically adds a space before the value in each
cell. How do I remove the space without clicking in each individual cell
and
deleting the space?

Use =TRIM(A1)

or

=RIGHT(A1,LEN(A1)-1)

Copy the results, then Edit -- Paste Special (Values).

Rgds,
Andy