We have a simple single line text column for email. The email address is essential for running a Power shell script so it's important is captured correctly. However, We've noticed some users entering spaces before and after the email address (most likely copying and pasting) which is causing issues with the script. How can I format the column to Trim the spacing before and after the text so that there is no spacing?
Thanks for your response however It does not seem to be working for me - the spaces still appear even after adding the TRIM function to the calculated value. How would Formula look on a single line of text column?