Removal of spaces within character string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Try the Replace() function.

Replace space with nothing (zero-length string).

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:D[email protected]...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

chop off last 5 characters of a string 9
Remove characters from end of string 3
String Function 3
Removing excess spaces in data 7
Removal of redundant spaces 2
How do I trim the last five characters from a string? 2
Remove spaces within a string 1
remove double space from string 26

Back
Top