ExcelBanter - similar function for SUBSTITUTE in excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - similar function for SUBSTITUTE in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/109042-similar-function-substitute-excel.html)

neb

similar function for SUBSTITUTE in excel?

in vba what is the similar function for SUBSTITUTE in excel? Can u pls help me?

Bob Phillips

similar function for SUBSTITUTE in excel?

REPLACE

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"neb" wrote in message
...
in vba what is the similar function for SUBSTITUTE in excel? Can u pls
help me?

neb

similar function for SUBSTITUTE in excel?

This is my code:

Sub nebs(Mycell)
nebs = Substitute(Mycell," ","")
End sub

(I want to make it as a function in excel using visual basic editor but
Substitute function is not defined/not recognized. I use REPLACE instead but
it asks me for a value...any help?)thnks.

"Bob Phillips" wrote:

REPLACE

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"neb" wrote in message
...
in vba what is the similar function for SUBSTITUTE in excel? Can u pls
help me?

neb

similar function for SUBSTITUTE in excel?

ITS WORKING NOW THNKS SO MUCH

"Bob Phillips" wrote:

REPLACE

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"neb" wrote in message
...
in vba what is the similar function for SUBSTITUTE in excel? Can u pls
help me?

All times are GMT +1. The time now is 08:43 PM.