You could use Find and Replace after importing - highlight the column
containing these ranges, and CTRL-H. In the Find What box enter 4-6 and
in the Replace With box enter 4,5,6, then click Replace All. You can do
this for other ranges in this style, then you can use
Data/Text-to-Columns to parse these using comma as the delimiter.

Hope this helps.

Pete