Split Function

[Guest]

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.

before:
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

 

[Norman Jones]

Hi Coco,

See Bob Phillips's response to your earlier, identical question.

 

[Norman Jones]

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