I have a problem which I was hoping someone could help me with.
I want to check if any part a number lies within another number.
For example lets say I had the variables:-
A = 48
B = 51
C = 50
D = 53
In this case I want to check if any numbers between C (50) through to D (53) fits...
Is there a way to generate a passphrase from a cell value either by formula or VBA. I have done a search this morning and cant find anything that fits what I would like. The cell value will be alphanumeric if this makes any difference