Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split Function
Can I use the Split function
to split each character contained in a cell? SplitByChar = Split(myVal, "") I try to use this VBA funcion for that particular case but I do not know if it is possible. befo A1:abc;hij after running vba: SplitByChar[0]=a SplitByChar[1]=b SplitByChar[2]=c SplitByChar[3]=; SplitByChar[4]=h SplitByChar[5]=i SplitByChar[6]=j Thanks Coco |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split Function
Hi Coco,
See Bob Phillips's response to your earlier, identical question. --- Regards, Norman "coco" wrote in message ... Can I use the Split function to split each character contained in a cell? SplitByChar = Split(myVal, "") I try to use this VBA funcion for that particular case but I do not know if it is possible. befo A1:abc;hij after running vba: SplitByChar[0]=a SplitByChar[1]=b SplitByChar[2]=c SplitByChar[3]=; SplitByChar[4]=h SplitByChar[5]=i SplitByChar[6]=j Thanks Coco |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split Function
Hi Coco,
If, for any reason, you are unable to see the response to your earlier post, here is a link: http://tinyurl.com/8ueqm --- Regards, Norman "coco" wrote in message ... Can I use the Split function to split each character contained in a cell? SplitByChar = Split(myVal, "") I try to use this VBA funcion for that particular case but I do not know if it is possible. befo A1:abc;hij after running vba: SplitByChar[0]=a SplitByChar[1]=b SplitByChar[2]=c SplitByChar[3]=; SplitByChar[4]=h SplitByChar[5]=i SplitByChar[6]=j Thanks Coco |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nees Function to Split | Excel Worksheet Functions | |||
Split function | Excel Programming | |||
VBA SPLIT FUNCTION | Excel Programming | |||
Split Function | Excel Programming |