I have a dataset with several thousand lines and I need to remove any characters after the last letter in the string. I have tried the "Trim" function and by using "-left(a2,find(" ",a2)-1)".
Neither of the formulas work which lead me to believe that there are no "spaces".
Please see the attached worksheet. Any help would be greatly appreciated.
Mike
Bookmarks