Re: Help with a Formula to turn various words into numbers

On Wednesday, July 25, 2012 3:36:13 PM UTC-7, College_Guru wrote:
> Hello ExcelBanter Experts,
>
>
>
> I'm soliciting help for a project. I have a column row with city names
>
> in them, I'd like to write a conditional formula that will convert those
>
> names into several different numeric values that we can use to evaluate
>
> them. problem is I have a LOT of cities and I need a great big formula
>
> to do. Any thoughts on how I can set this up?? I'm using Excel 2007.
>
> Thanks in advance.
>
>
>
>
>
>
>
>
>
> --
>
> College_Guru



On Wednesday, July 25, 2012 3:36:13 PM UTC-7, College_Guru wrote:
> Hello ExcelBanter Experts,
>
>
>
> I'm soliciting help for a project. I have a column row with city names
>
> in them, I'd like to write a conditional formula that will convert those
>
> names into several different numeric values that we can use to evaluate
>
> them. problem is I have a LOT of cities and I need a great big formula
>
> to do. Any thoughts on how I can set this up?? I'm using Excel 2007.
>
> Thanks in advance.
>
>
>
>
>
>
>
>
>
> --
>
> College_Guru



On Wednesday, July 25, 2012 3:36:13 PM UTC-7, College_Guru wrote:
> Hello ExcelBanter Experts,
>
>
>
> I'm soliciting help for a project. I have a column row with city names
>
> in them, I'd like to write a conditional formula that will convert those
>
> names into several different numeric values that we can use to evaluate
>
> them. problem is I have a LOT of cities and I need a great big formula
>
> to do. Any thoughts on how I can set this up?? I'm using Excel 2007.
>
> Thanks in advance.
>
>
>
>
>
>
>
>
>
> --
>
> College_Guru



On Wednesday, July 25, 2012 3:36:13 PM UTC-7, College_Guru wrote:
> Hello ExcelBanter Experts,
>
>
>
> I'm soliciting help for a project. I have a column row with city names
>
> in them, I'd like to write a conditional formula that will convert those
>
> names into several different numeric values that we can use to evaluate
>
> them. problem is I have a LOT of cities and I need a great big formula
>
> to do. Any thoughts on how I can set this up?? I'm using Excel 2007.
>
> Thanks in advance.
>
>
>
>
>
>
>
>
>
> --
>
> College_Guru