how to delete a string from another string

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.

=SUBSTITUTE(A1,"niel",)

--
Kind regards,

Niek Otten

"Ribap" <Ribap.23mwep_1140617405.4389@excelforum-nospam.com> wrote in
message news:Ribap.23mwep_1140617405.4389@excelforum-nospam.com...
>
> 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.
>
>
> --
> Ribap
> ------------------------------------------------------------------------
> Ribap's Profile:
> http://www.excelforum.com/member.php...o&userid=25382
> View this thread: http://www.excelforum.com/showthread...hreadid=515303
>

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

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

--
Kind regards,

Niek Otten

"Ribap" <Ribap.23mxsn_1140619202.8991@excelforum-nospam.com> wrote in
message news:Ribap.23mxsn_1140619202.8991@excelforum-nospam.com...
>
> 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
>

Thanks a lot, it works great.

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



Niek Otten wrote:
> a = Application.WorksheetFunction.Substitute(a, "niel", "")
>
> --
> Kind regards,
>
> Niek Otten
>
> "Ribap" <Ribap.23mxsn_1140619202.8991@excelforum-nospam.com> wrote in
> message news:Ribap.23mxsn_1140619202.8991@excelforum-nospam.com...
> >
> > 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
> >