Removing Spaces in a string

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

Guest

What Function or ??? can I use to remove blank spaces within a string?
Example: FS 8406 PT 1 to read FS8406PT1. Anyone with any ideas.

thanks in advacnce
 
So Simple, Thank you

KARL DEWEY said:
Replace([YourFieldName], " ","")
--
KARL DEWEY
Build a little - Test a little


hdfixitup said:
What Function or ??? can I use to remove blank spaces within a string?
Example: FS 8406 PT 1 to read FS8406PT1. Anyone with any ideas.

thanks in advacnce
Click to expand...
Click to expand...
 
Back
Top