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.


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

how to delete a string from another string
 

=SUBSTITUTE(A1,"niel",)

--
Kind regards,

Niek Otten

"Ribap" wrote in
message ...

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

how to delete a string from another string
 

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

how to delete a string from another string
 

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

how to delete a string from another string
 

Thanks a lot, it works great

--
Riba
-----------------------------------------------------------------------
Ribap's Profile: http://www.excelforum.com/member.php...fo&userid=2538
View this thread: http://www.excelforum.com/showthread.php?threadid=51530

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