Thread: Replace
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ren Ren is offline
external usenet poster
 
Posts: 67
Default Replace

Got it!!!!!

Thanks so much!!!!!!

Greetings from US :)

"Bill Kuunders" wrote:

One way

enter in a help column say column C
=IF(A2="Champion","SanFrancisco",B2)
extend this down and change into values by using
edit ,copy,, paste special,, values
delete column B

--
Greetings from New Zealand

"Ren" wrote in message
...
How can I replace Champion's location? Ajax and Champion have the same
location- but i need to change Champion's location from New York City to
San
Francisco.


Customer Customer Location
Ajax New York City
Champion New York City
Baker Toronto
Ajax New York City
Champion New York City
Ajax New York City
Ajax New York City
Baker Toronto
Champion New York City
Ajax New York City
Champion New York City
Baker Toronto
Ajax New York City
Champion New York City
Champion New York City
Baker Toronto
Ajax New York City
Champion New York City
Baker Toronto
Ajax New York City