Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace
You are looking to **permanently** replace the Champion "New York City" with
"San Francisco", right? Assuming your data starts on Row 2, put this formula in a helper column (assumed to be Column C for this example)... =IF(A2="Champion","San Francisco",B2) and then copy it down through all of your data rows. Next, select from C2 down to the last data row in C; then select Edit/Copy from Excel's menu bar (or, alternately, key-in Ctrl+C); then make B2 the active cell and select Edit/PasteSpecial form Excel's menu bar, select the Values option button from the Paste section of the dialog box and click the OK button; then hit the Esc key to unselect the Column C cells; and, finally, delete all of Column C. Rick "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replace
sub changelocation()
for each c in range("a2:a22") if c="Champion" then c.offset(,1)="San Francisco" next c -- Don Guillett Microsoft MVP Excel SalesAid Software "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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
Can I replace a ' at the beginning of a text cell using Replace | Excel Discussion (Misc queries) | |||
Replace dialog should put focus on "Find What" not "Replace With" | Excel Discussion (Misc queries) | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
How can I use replace(alt+H) for mutiple items needing replace | Excel Worksheet Functions |