Find and Replace

[jamming1]

I am in the telecom industry and I program telephone switches anywhere from 100 users to 10000 users. I use Excel as my source of the database to do my programing and run automated tasks. Some of my jobs involve moving customers from one building to another and that requires users to get new phone numbers.

When I get into this situation of moving to a new building the users want there phones to stay the same, just with the new numbers in place of the old number. So I download the existing programing into Excel and just add a column for the new number. So for years I have been just using the normal replace command in Excel to search the spreedsheet and replace any instace of the old number with the new number. I have attached an exapmle of the spreedsheet for reference.

So long story even longer...I am looking for an automated way of doing this. Is there a way of doing this through a formula? If so can someone point me in the right direction to get me started. Or if this is a simple thing for an expert and can give me and example formula to modify I would be very gratefull for that. I searched in Googled but that just comes up with someone trying to sell me a Excel add program that isnt what I'm looking for. Believe me if there was one out there that fit my need I would have bought it by now.

Thanks in advance!

Jeff

[StephenR]

Based on our example, would this do? In E18 and copy across and down as necessary:

=VLOOKUP(E4,$A$4:$B$11,2,FALSE)

However, your use of the term automated may require code. This would be true if you wanted the old numbers overwritten by the new.