Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split Function gives rn-time error
Hello David, The Split function returns an Array of the separated elements in th string. The first element of the Array is zero the last element i found using the UBound function. You have to rebuild the string fro the array elements. You might want to use the Replace functio instead. Code ------------------- Sub test() Dim txt as String txt = Replace("abc;xyz;456m;9a6d", ";", Chr$(vbKeySpace)) Msgbox Txt End su ------------------- Sincerely, Leith Ros -- Leith Ros ----------------------------------------------------------------------- Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846 View this thread: http://www.excelforum.com/showthread.php?threadid=48097 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
freeze and split at the same time? | Excel Discussion (Misc queries) | |||
Insert Function next to formula bar gives Run-time Error '50290' | Excel Discussion (Misc queries) | |||
Worksheet function match - run time error | Excel Worksheet Functions | |||
Split date and time | Excel Discussion (Misc queries) | |||
Split Function gives rn-time error | Excel Programming |