Hello verybody,

Please help over here.

I have all numbers that begin with 7 linked with the Key "WRF" like this:

A B
7 WRF

But if I want to link another key (QQP) with another number that begins with 7 (e.g. 7837) I need
to expand all the 7 series in order to cover all numbers that begin with 7. leaving all linked with WRF and
only 7837 linked with QQP like in table below.

A B C D E
7 0 WRF
7 1 WRF
7 2 WRF
7 3 WRF
7 4 WRF
7 5 WRF
7 6 WRF
7 7 WRF
7 8 0 WRF
7 8 1 WRF
7 8 2 WRF
7 8 3 0 WRF
7 8 3 1 WRF
7 8 3 2 WRF
7 8 3 3 WRF
7 8 3 4 WRF
7 8 3 5 WRF
7 8 3 6 WRF
7 8 3 7 QQP
7 8 3 8 WRF
7 8 3 9 WRF
7 8 4 WRF
7 8 5 WRF
7 8 6 WRF
7 8 7 WRF
7 8 8 WRF
7 8 9 WRF
7 9 WRF


I hope some excel expert could help me with this.

Any help would be appreciated.

Regards