Help file for the TRIM() function notes two different kinds of space character: https://support.office.com/en-us/art...rs=en-US&ad=US

Ardnas: This forum is pretty strict about not posting your question in another user's thread. If that doesn't answer your question, start your own thread. You can link back to this thread if you feel that it helps you explain your question/problem.