split the characters separated by colon

hi friends
I have a collections of characters like this

ssplitcol= J:K,L,M,N
from this i took K as
ipos= instr(1,ssplitcol,":")
ssplitFrom = Left(splitCols, iPos - 1)
The result i got is J

but my need is :
if ssplitcol= K,L,M,N:J
then how to extract J from this
Please help me out in this
thanks
bujji

I got the solution friends

ssplitColFRM = Right(splitCols, (Len(splitCols)) - (iPos))
this will give the result

Highlight the cells, columns or rows you need seperated.
Under the Data tab in Data tools select 'text to columns'.
Select 'delimited'.
Click next.
Check box in 'other' and type : into text box.
Ckick next and finish.
That's it. As long as you are using MSO2007-10.

Thank u brownie.. but i got the solution to my query.....