G Guest Sep 6, 2006 #1 How do I delete spaces in between text? Trim doesnt work. And if it is Replace, what is the exact syntax? Thanks,
How do I delete spaces in between text? Trim doesnt work. And if it is Replace, what is the exact syntax? Thanks,
D Duane Hookom Sep 6, 2006 #2 You can remove all spaces from a string using Replace([YourField]," ","")
G Guest Sep 6, 2006 #3 If you are talking about removing multiple space to use only one try this -- Replace([YourField]," "," ") Or to remove all spaces then this -- Replace([YourField]," ","")
If you are talking about removing multiple space to use only one try this -- Replace([YourField]," "," ") Or to remove all spaces then this -- Replace([YourField]," ","")
