Did you try "Text to Column" using " # " as the delimiter ?