I have a spreadsheet showing variable strings however I want to remove all character that appear after / e.g
'Virgin Islands/123/7 H %' should appear as just 'Virgin Islands'.
The strings and the characters after the '/' are variable in length so the replace function using '/????' will not work...