I have a client that copies directions from Google and pastes into a text field in FileMaker 12. The pasted data includes hidden columns from Google that I can't find a way to remove when they paste. I've tried multiple custom functions, but none remove the extra spaces. This creates a problem when the directions are printed. Any idea?
The CF's I've tried are: