Check out the Excel Add-in called ASAP Utilities..........it's available free
at www.asap-utilities.com

It has a feature to do just what you want.......

Vaya con Dios,
Chuck, CABGx3



"elaine" wrote:

> 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.
>
>