How about a nice macro?

Sub replacedashwithspace()
Columns("c").Replace "-", " "
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Turkey" wrote in message
...
What is the formula to replace "-" with space starting to count from the
right side. I need this to be done in a whole column