Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Replace/Look up
Hi! Ok, so I have a list of cost centres e.g 2000,2411,2582 these have been replaced with new cost centre numbers e.g. 8500,8548,8449 so that now: 2000 = 8500 2411 = 8548 2582 = 8449. I will have spreadsheets submitted where the old cost centres will be referenced. What I want to do is; search the spreadsheet for the old cost centres, and replace the value with the corresponding new cost centres. something faster than a simple find and replace because there are hundreds of cost centres. -- Mr_Philip ------------------------------------------------------------------------ Mr_Philip's Profile: http://www.excelforum.com/member.php...o&userid=31415 View this thread: http://www.excelforum.com/showthread...hreadid=523121 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find and Replace/Look up | Excel Discussion (Misc queries) |