[kikee122]

Hello, I am new to basic programming and wasn't sure which thread this should go in.

I have a little program which I need to write which essentially does the below:

I have a data set for example:

103848291
29381
3208019
392791145

They need to be formatted based on a predefined data range. So, for example:

PC0000029381
QQQ103848291

Based on whether the number falls between a certain range, I need it to be prefixed by either PC or QQQ and based on the range, I need to assign a certain number of zero's

So, for example

LOWER RANGE:
QQQ00192284

UPPER RANGE:
QQQ00039947

So based on the dataset (at the top of the tread) I need to say:


29381 falls between this range. So it should have

QQQ and three 0's in front of the number.


I have started trying to code this out; and have managed to use an if statement to clear out unwanted data, but really have no idea where to start on this part of the script.

It seems like I need to remove the first few letters from the ranges (e.g. QQQ and then compare the data?)

Any and all help would be greatly appreciated!

[kikee122]

As added information. The data list is in an Excel file and could be updated frequently.