Removing leading spaces

Hello Andrew,

Hope you enjoyed your Microsoft Access courses with Best STL.

Thank you for your question regarding removing leading spaces from data imported from Excel.

The spaces in the Excel data may simply be Indented data which gives the appearance of having spaces. If this is the case then the TRIM function in Excel will remove indents as well as leading and trailing spaces.

I presume that you have already tried this in Excel?

What I would do is first try the TRIM function in Excel to see if this works. If it does I would then create a macro to automate the process over the many columns you have in the sheet.

Should this fail to work and your only choice is to remove the spaces in Access I have added some links to resources that may be of use to you. These are as follows:

http://www.utteraccess.com/forum/Remove-Extra-Spaces-Str-t1970618.html

http://office.microsoft.com/en-ca/access-help/remove-spaces-from-the-beginning-and-end-of-a-text-value-HP001099033.aspx

http://www.techonthenet.com/access/functions/string/trim.php

Give these a try. I'm sure you will be able to fix the problem one way or another.

Have a great weekend!


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer