=SUBSTITUTE(A1,"-","")

HTH
Jason
Atlanta, GA

"Brad" wrote:

i have a column of phones numbers with the format 555-111-2222 and I want to
remove the dashes so that they are 5551112222 so that I can use a vertical
lookup. What's the easiest way to do this?