Replace "dash" with "space"

Turkey · Apr 30, 2009

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

Bob Phillips · Apr 30, 2009

=SUBSTITUTE(B1," ","-",LEN(B1)-LEN(SUBSTITUTE(B1," ","")))

and copy down

Don Guillett · Apr 30, 2009

How about a nice macro?

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