Help with Right(Me.ListStoreIP.Column(0), 2)

[Guest]

I think there is a way to find # and use the value to the right of the number
sign
Any help would be great
Tobacco Rd Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #02
Right(Me.ListStoreIP.Column(0), 2) = 2 Right
Tobacco Road Outlet #112
Right(Me.ListStoreIP.Column(0), 2) = 12 Wrong

 

[Guest]

mid(mystring,instr(mystring,"#") + 1)

 

[Guest]

Thanks Joel
Can I ask whats the +1 do

mid(mystring,instr(mystring,"#") + 1)

 

[Guest]

Looks like it moves the start position one space to the right of the # so it
should return everything to the right of the # sign. Does it?