is it always a
space apostrophe space

if so then you can do a

Mid(cell, 3, len(cell)-3)
which will remove the

then add value to change text to a number
assuming number in cell B3

=VALUE(MID(B3,3,LEN(B3)-3))