what does a proper string look like?
=trim(mid(a1,5,255)) is another one
you could also use text to columns fixed width and skip the first column