removing text on the right

Hello i been having a bit or a problem trying to work on this i need to remove the text on the right (REF NFS-E N° (number)) i thought of just removing the number and then the text but i cant since some times the name on the left has a number so im kinda stumped i have an idea with padding on the left and then limiting to a size to remove all on the right but if i ever find a job with a name big enough that might cause problems so is there a way for me to just remove text on the right (like remove 18 characters from the right?)

thank you for your time

Would the Cell Splitter solve your problem?

it is exactly what i needed thank you very much