Extract special characters from a string

Hey Excel community,

I was wondering if excel can solve my question.

I have many rates in different units, I would like to exract only the units from these rates.

For example
US$ 4.55 /Kg I would like to get US$/Kg
US$ 4.82/unidad I would like to get US$/unidad
US$ 42.97/gruesa I would like to get US$/gruesa
US$ 45,29/t I would like to get US$/t
US$ 889.08/tonelada I would like to get US$/tonelada

there are about 3000 different rates, Therefore, I have to find one function in EXCEL to do this automatically

Could anyone help?

Thanks

This should extract what you want if the data starts in A1. Enter the formula in B1 and copy down.

Formula:

Please Login or Register  to view this content.