How to get rid of extra spaces in text file

[Nestor]

How do i get rid of spaces (blank spaces).

example:

Corona123 =123 is for extra blank spaces.

budweiser123456 =123456 is for extra blank spaces.

[Ender]

I'm afraid your example did not help. Perhaps your example was 'fixed' by the Forum (it automatically removes extra spaces in posts, unless you use the

tags.)

[Zero Tolerence]

I believe what he's saying is that 123 and 123456 are supposed to be his extra spaces. But he's subed them for the forum. Although I could be wrong. If this is the case Nestor, use the Trim() Function

Trim removes extra spaces at the begginning and the end of the field. If, however, that is not the case and your comming up with extra spaces in the middle of your field like:

hi       there     how    are    you    ?

 You could do something like

Substitute(text; ["     "; " "]; ["    "; " "]; ["   "; " "]; ["  "; " "])

Should work. Thats assuming you only ever want one space inbetween anything of course.

[Nestor]

The trim function is exactly what i want to do. I want to be able to get rid of spaces at the end of the word. How would you use the trim function for the examples above. Thanks in advance

[Lee Smith]

Why not just use the TrimAll Function?

[Nestor]

The trim all function worked perfectly. thanks for all the help..