In regard to Multiple Substitute Formula, here’s one way to do it in VBA.
Sub RemoveStates()
Dim rInput As Range
Dim rStates As Range
Dim vaInput As Variant
Dim vaStates As Variant
Dim i As Long, j As Long
Dim sTemp As String
Set rInput [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/12/10/multiple-substitute-vba/
Posted
Dec 10 2009, 05:43 PM
by
Daily Dose of Excel