VBA Replace number

[Ezguy4u]

I would like to replace the number 5 with the number4. I would like to use VBA. If there are any questions, comments or suggestions, please let me know.

find and replace.xlsx
	A	B	C
1	Amount In		Amount Out
2	3256		3246
3	8912		8912
4	65		64
5	5892		4892
Data

 

[MARK858]

One way...

Sub Replace5()
 Range("C2:C5").Value = Range("A2:A5").Value
 Range("C2:C5").Replace "5", "4", xlPart
End Sub

 

[Fuji]

Or

Sub test()
    [c2:c1000] = Application.Substitute([a2:a1000], 5, 4)
End Sub

 

[Ezguy4u]

I really love this web page. Mark thank you for your solution to my problem. I will be putting your solution into my excel toolbox. Fuji I will be marking your solution as the answer because it has one line of code. I really appreciate seeing the Replace and Substitution function. Thank you both for you time