Hiya,

I have a flat database in excel with the problem that some text fields
have leading spaces, which mucks the sort. I don't have the access
database.

It's not clear to me how trim can help with this problem.


from the help page:

=TRIM(A2) Removes the trailing space from the string "BD 122 " (BD 112)


However, I want the *leading* spaces, not the trailing spaces. I don't
want a VB script or macro, but are those the only options?

I can group the offending rows, export them to notepad, and re-import.
Is there something import can do to simply ignore leading spaces for
imports? Not all spaces, just leading.




thanks,


Thufir