Hi,
I have a telephone list at work that I work on. In some cells there's more than one extension number shown so, for example, in cell B10 there is:
23109, 23146, 23148
This is great, except people mainly call the first number in the list, which can be a bit annoying!
Is there any way to randomise these 3 numbers in that cell so that it shows a different number every time the worksheet is opened?
Thanks,
Dan.
Bookmarks