Trimming a string containing numbers and text

[#1]

Hi I have the following data with the current data and expected data. What's the best way to get this output ?

Is it perhaps easier to do this in excel ?

Many thanks

[#2]

Hi Sid,

U can try this,

=mid(CURRENT,Index(CURRENT,'-')+1)

Thanks