how to delete a string from another string

[Ribap]

Hello, i want to delete a string from another string, like the example
below:

variable: "daniel" - "niel"

so in my variable i would have "da"

how can i do it??

thanks.

 

[Niek Otten]

=SUBSTITUTE(A1,"niel",)

 

[Ribap]

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

 

[Niek Otten]

a = Application.WorksheetFunction.Substitute(a, "niel", "")

 

[Ribap]

Thanks a lot, it works great

 

[Andrew Taylor]

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

a = Application.WorksheetFunction.Substitute(a, "niel", "")