Change the actual data

[Guest]

is there a way to change 555-444-8888 (dashes are actually entered in) into 5554448888?

 

[Steve Garman]

MsgBox Replace("555-444-8888", "-", "")

(may not work in older versions of Excel)

 

[Steve Garman]

I didn't notice the subject.

You may be looking for something more like:

ActiveCell.Formula = Replace(ActiveCell.Value, "-", "")

 

[Frank Kabel]

Hi Jee
try something like
with Range("A1")
.value = replace(.value,"-","")
end with

 

[Tom Ogilvy]

Select you range of cells

do
Edit=>Replace
what -
With leave blank.

--
Regards,
Tom Ogilvy

is there a way to change 555-444-8888 (dashes are actually entered in)

into 5554448888?