Removal of spaces within character string

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Grape Hunter - 25 Sep 2005 03:24 GMT

Access 2003. Wanting to generate a VBA "black box" routine to remove spaces
from within text strings of varying lengths. There is no issue with leading
or trailing blank spaces. Think of it as removing all the blanks between
words in a sentence. Seems there might be a tool or trick I'm just not
finding. As always thanks for the great help made available here.

Reply to this Message

Allen Browne - 25 Sep 2005 03:28 GMT

Try the Replace() function.

Replace space with nothing (zero-length string).

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Access 2003. Wanting to generate a VBA "black box" routine to remove
> spaces
[quoted text clipped - 3 lines]
> words in a sentence. Seems there might be a tool or trick I'm just not
> finding. As always thanks for the great help made available here.

Reply to this Message