Making "examp le" become "examp_le" in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there and easy way to find and replace the " " in the example above to
"_"? . If not I will have to loop throught each character in the string
using the left and right functions and then recompile the string.
 
Thanks. I'll be using Applicaiton.WorksheetFunction.Substitute(variable," "_")
 
See if your version of Excel supports the Replace VBA function. I think it was
introduced in v 2000. If it does, I would use that instead.
 
You must log in or register to reply here.

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

Replace a character by it's place in a string 2
Cannot Dechiper Encoded String 10
Separating parts of a string in VBA 4
Function not working on one machine 2
Remove the right most 3 characters from a string 10
Len and InStr problem manipulating strings 3
How make long string in a cell become text line by line in same cell? 4
macro on different reports CTRL+F in formula 2

Back
Top