Paul,
If i understood your requirement correctly then below formula works out for
you
[image: Inline image 1]
I have attached sample file as well.
Regards,
Karthik
On Thu, Feb 11, 2016 at 5:57 AM, Paul Bevins
wrote:
> Hi, I've got an odd problem.
>
> I have a
Hi, I've got an odd problem.
I have a database of some 15000 numbers.
10,000 of them (roughly), go from 1 to 10,000.
Another 5,000 go from 1,000,000 to 2,000,000.
However, the numbers SHOULD AB1 to AB1.
I need to be able to type the root number in and have Excel decide what it
needs: