Thread: Split Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Coco Coco is offline
external usenet poster
 
Posts: 34
Default 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