This content has been marked as final. Show 2 replies
Those functions mainly remove spaces, not what you want here. Looks like all you need is:
Leftwords ( Yourfieldhere ; 1 )
To get all text to the left of the first word separator character ( space, return, punctuation characters....)
Thanks so much!