Remove suffixes from end of data

[dicko222]

I have a database of design but can have up to 8 different suffixes depending who they are for but basically its the same item

I need a way of remove certain characters from the end of string as per the supplied sample

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread (with proposed solution): https://www.excelforum.com/excel-for...of-string.html