View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew Taylor Andrew Taylor is offline
external usenet poster
 
Posts: 225
Default how to delete a string from another string

Or :
a = Replace(a, "niel", "")



Niek Otten wrote:
a = Application.WorksheetFunction.Substitute(a, "niel", "")

--
Kind regards,

Niek Otten

"Ribap" wrote in
message ...

yeah, but i need to do this in vba code, and that code does not work in
vba


--
Ribap
------------------------------------------------------------------------
Ribap's Profile:
http://www.excelforum.com/member.php...o&userid=25382
View this thread: http://www.excelforum.com/showthread...hreadid=515303