E
elaine
Is there a simpler way to remove symbols from a string?
I found the following code from previous postings:
Sub Example()
Worksheets("Sheet1").Columns("A").Replace _
What:="-", Replacement:="", _
SearchOrder:=xlByColumns
End Sub
I tried adding these in the code:
What:="£", Replacement:="", _
What:="$", Replacement:="", _
What:="%", Replacement:="", _
What:="/", Replacement:="", _
But it doesnt work. It said "Named argument not found"
Is there anyway to delete all the symbols from a column with lists of
strings such as:
123 Oxford Street to Oxford Street
2 Abbey Road to Abbey Road
Apple-pie to Applepie
Ice-Cream to Icecream
easy.jet to easyjet
1. need to delete all the symbols from a string
2. need to delete all the numbers from a string
Please help.
I found the following code from previous postings:
Sub Example()
Worksheets("Sheet1").Columns("A").Replace _
What:="-", Replacement:="", _
SearchOrder:=xlByColumns
End Sub
I tried adding these in the code:
What:="£", Replacement:="", _
What:="$", Replacement:="", _
What:="%", Replacement:="", _
What:="/", Replacement:="", _
But it doesnt work. It said "Named argument not found"
Is there anyway to delete all the symbols from a column with lists of
strings such as:
123 Oxford Street to Oxford Street
2 Abbey Road to Abbey Road
Apple-pie to Applepie
Ice-Cream to Icecream
easy.jet to easyjet
1. need to delete all the symbols from a string
2. need to delete all the numbers from a string
Please help.