Displaying Range in Text

[Katiee]

Hi all,

This may be extrememly simple but here goes..

Is there a way or formula to display in one cell the range of a selection of numbers. By range I don't mean the simple 'highest number - lowest number) - I mean for it to literally say 'The range is 2 - 9'.

Thanks.