Right vba function

Question

I want to take everything to the right of a character in a string I used

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

where is the private value 29,6 *60

, so I need to return *60

, but now it returns

,6 *60

Sorry if this question has already been asked, I have just started using vba and I am a little confused

+3

vlad June 15. '15 at 6:34

3 answers

If you must use Right

:

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

Indeed, Mid

this is the way to keep the code short and readable.

+1

The fastest way to do this is to use it Right

as a string function Right$

. See here

The biggest gain is achieved with a string function (i.e. Mid$

much superior Mid

)

Descending order:

+1

brettdj June 16 '15 at 9:15

Kazimierz Jawor · Accepted Answer · 2015-06-15T06:38:58+0000

try instead Mid

:

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