Sorry, Ron. Let me go back. The application is to manage the impact of Do
Not Call Lists. The data changes daily. We typically work from reverse
phone directories, which list all the numbers in an area code. I I'm trying
to create a list of callable numbers along with whatever contact information
is available in the Reverse Phone Books.

The data in the RPB's is not consistent - but it is consistent enough that
the formula you created works for the data for Calgary. To be generically
useful, I need to be able to allow users to just input the city for their
Area Code. The rest of the data is available...

So, I can use a variable, or it will also work if we remove the reference to
the city - totally. Either will be fine.

I'd like to use a variable - if only to see how it's handled. But if it
can't be, would you please redo the formula and remove the city reference?

Thanks again
Jim


"Ron Rosenfeld" wrote in message
...
On Wed, 2 Jun 2010 09:23:43 -0600, "Jim Berglund"
wrote:

...or what if we entered the city from an input box, determined the length
of the name and counted back from the comma?
Jim



If you can control how data is input, then you don't need any of the
parsing routines. Merely use a user form to input the data into the
appropriate form fields.