Replace "dash" with "space"

T

Turkey

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
 
D

Don Guillett

How about a nice macro?

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zeros in cells 2
Problem With Text & number format 1
Replacing dash in item number 3
Parsing text containing a tilde "~"? 6
Macro to clear contents of certain cells 4
Replace Comma with "-" 2
Replace Comma with "-". 1
Convert a phone number 3

Top