Right function vba

Question

I want to take everything to the right of the symbol in the string I used

Right(enclosedValue, InStr(enclosedValue, "*") - 0)

where enclosed value is 29,6 *60, so I need it to return *60, but now it returns

,6 *60

Sorry if this question has been asked already, I have just started using vba and I'm a bit confused

Answer 1

try with Mid instead:

Mid(enclosedValue, InStr(1, enclosedValue, "*"))