How do I delete spaces in between text? Trim doesnt work.

  • Thread starter Charu Ramakrishnan
  • Start date
C

Charu Ramakrishnan

How do I delete spaces in between text? Trim doesnt work. And if it is
Replace, what is the exact syntax? Thanks,
 
K

KARL DEWEY

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]," ","")
 
Top