Split Concatenated String

[twoplustwo]

Hi guys,

Hope you're all well.

Any ideas on the most efficient way to isolate the last characters in the below string:

"HW $161.14 Q45BB6LPQ5"

The number of spaces between the dollar value and code might change fwiw.

Thanks.

 

[vbaInet]

What part of the string do you want to extract?

 

[twoplustwo]

Should have been clearer The end " Q45BB6LPQ5" part.

 

[vbaInet]

Plus the leading space?

 

[MSAccessRookie]

Based on the example that was provided, I would assume that using a combination of the Right(), Len(), and InstrRev() should be what you are looking for. Something like:

Right(YourString,InstrRev(YourString, " ",Len(YourString))-1)

 

[twoplustwo]

Spot on, thanks gents.