use a vlookup table

Create your table on a new sheet (name the range "MyList") with Char |
Charleston, San | San Diego, Det | Detroit, Chi | Chicago, Lon |
London....etc. in adjacent columns and sort ascending.

In your first cell in col C (Cn) enter =VLOOKUP(Bn,MyList,2) {change
the 'n' to match the row you are in}

Copy this formula down your desired range

entering San in Bn will return San Diego in Cn

Question: How will you handle San Jose, San Antonio, etc.?

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=346038