The Trim function in Access only removes extra spaces at the beginning and ending of a text string.
If I have a text string like this,
"JOHN Q PUBLIC"
Is there any way I can remove the extra spaces inside the string, so it reads like this:
"JOHN Q PUBLIC"
If I have a text string like this,
"JOHN Q PUBLIC"
Is there any way I can remove the extra spaces inside the string, so it reads like this:
"JOHN Q PUBLIC"