Displaying Range in Text

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.

Try:

Formula:

Please Login or Register  to view this content.

& will join two strings together.

Hi,

Very little information to go on, but perhaps:

="The Range is "&MIN(A1:A100)&" - "&MAX(A1:A100)

Regards