| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete a string | Excel Worksheet Functions | |||
| Importing Long String - String Manipulation (INVRPT) (EDI EANCOM 96a) | Excel Programming | |||
| Delete value in a string | Excel Programming | |||
| to search for a string and affect data if it finds the string? | Excel Worksheet Functions | |||
| Create a formula into a String then assign string to a cell | Excel Programming | |||
Linear Mode
