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