Is there a "replace" or "Substitute" command in Excel's VB?

  • Thread starter Thread starter tanast
  • Start date Start date
T

tanast

Hi,

I was hoping someone could help me with a quick question.

Is there a command something like "substitute" or "replace"?

I basically want a command that will replace all instances of a
particular character with another character... For example, I'd like
to remove all the spaces from the string "hello there world" to make
it "hellothereworld".

Any help would be much appreciated.

Thanks
 
Hi, you can also use "Substitute" as follows.

sString = "Hello World!"
sString = Application.WorksheetFunction.Substitute(sString, " ", "")

Note:Replace works on Excel 2000 and later version.


--
Kind Regards
Colo
/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Colo of 'The Road of The Cell Masters' :)

URL:http://www.interq.or.jp/sun/puremis/colo/CellMastersLink.htm
mailto:[email protected]

/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
 

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

Is there a "replace" or "substitute" command in Excel's VB? 5
Using substitute to replace text that varies 3
wildcards with substitute of replace 5
Need help in using INDIRECT, SUBSTITUTE, and OR in a formula fordependent dropdown list 2
Deleting characters after 3rd occurence of a string 4
Find and replace a character in a cell with another cell's content 1
Replace Function in Excel 97 6
Trimming leading character from string and replace underscore withdashes 4

Back
Top