View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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