Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split function
I have a question:
Can I use the "split" function to split one by one, EACH Character of a what is contained in a cell. I mean, can I use something like this? SplitAllChar= Split(myVal, "") Thanks Coco |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split function
Don't think so, you have to do it yourself
ReDim SplitAllChar(1 To Len(myVal)) For i = 1 To Len(myVal) SplitAllChar(i) = Mid(myVal, i, 1) Next i -- HTH RP (remove nothere from the email address if mailing direct) "coco" wrote in message ... I have a question: Can I use the "split" function to split one by one, EACH Character of a what is contained in a cell. I mean, can I use something like this? SplitAllChar= Split(myVal, "") Thanks Coco |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Split function
According to the VBA help file " If delimiter is a zero-length string, single-element array containing the entire expression string i returned." You could add a space after each character and then perform the spli with space (" ") as the delimiter -- bhofset ----------------------------------------------------------------------- bhofsetz's Profile: http://www.excelforum.com/member.php...fo&userid=1880 View this thread: http://www.excelforum.com/showthread.php?threadid=37982 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nees Function to Split | Excel Worksheet Functions | |||
Split Cell using If or other function | Excel Worksheet Functions | |||
VBA SPLIT FUNCTION | Excel Programming | |||
Split Function | Excel Programming |