Hello,
I receive excel files that I need to enter into a data base. The excel files include rows of telephone number ranges. Some telephone number ranges include the entire 10,000 number blocks and some don't. Some of these spreadsheets I receive have 1,000's of rows so that is why I am trying to automate this process. some examples are below. What I am trying to figure out is a way within excel that I can create additional columns of data based on a test of the starting and ending subscriber numbers. My thoughts have been to create a big IF statement, but have not been able to come up with the flow. Any ideas?
thanks
Bob
I receive data in the following format.
NPANXX starting Subscriber # Ending Subscriber #
620561 0000 4999
So what I am interested in doing is creating a way for me to that the data above and translate it into the following.
6205610
6205611
6205612
6205613
6205614
Another example would be
NPANXX starting Subscriber # Ending Subscriber #
620561 7999 8999
This would become
6205617
6205618
Another example would be
NPANXX starting Subscriber # Ending Subscriber #
620561 0000 9999
For this one since the telephone number range includes the entire 10,000 block, it should be
620561
Bookmarks