Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Find and replace
I have a table with 6 columns, A to F. Column A contains unique item numbers. Column B contains descriptions of those items. Columns C-F contain a random listing of the numbers from column A. I want to replace the random listings of items in C-F with the descriptions of the items from column B. There are 1300 items. Can I do this without running 1300 Find and Replaces? I would be happy with four new columns added that have the descriptions for the random items in C-F in the same order (not exactly a replace). Thanks! Al -- ovid962 ------------------------------------------------------------------------ ovid962's Profile: http://www.excelforum.com/member.php...o&userid=35452 View this thread: http://www.excelforum.com/showthread...hreadid=552302 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro: Find and replace | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Find & Replace in VB macro | Excel Discussion (Misc queries) | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
VB Find and Replace | Excel Worksheet Functions |