Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
want to create a find and replace formula
in column A A1)1 A2)4 A3)3 in column b I have numbers that relate to vehicle makes b1)1 b2)2 b3)3 in C I have makes c1)Ford C2)Chevy C3)Dodge the numbers in column b relate to the makes in c so 1=Ford 2=Chevy 3=Dodge I want to find the number in column A and have it replaced with the correct make. so if a1=1 then change it to ford if A2=3 then change it to dodge I relaliz I can do this one by one using find and replace but is there a way to do a batch find and replace any one know how to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to cancel a find & replace command "midstream"? | Excel Worksheet Functions | |||
Macro: Find and replace | Excel Discussion (Misc queries) | |||
Find and Replace | Excel Worksheet Functions | |||
Find and replace of word causes change of font formatting | New Users to Excel | |||
VB Find and Replace | Excel Worksheet Functions |