I have a string in a cell where the length changes but I always want to truncate after the last number reading from left to right.

I'm not sure if truncate is the correct function to use, or how to do it.

Thanks