Split() method

I cannot get the Split() method in VBA to work when there is leading whitespace.

Also if I try to compare a string to the text in a cell, I have to actually copy the value from the cell and paste it into my VBA code for it to be equal. Even if I have the exact same string in my VBA code that I typed in, it will not say they are equal.

if suppose cell b2 = " testing , 456 , 567 "

then in vba

dim t as variant

t=split(range("b2").value,",") 'splitting with delimiter comma (,)

if ubound(t)>0 then

for i=0 to ubound(t)
msgbox t(i)
next

end if

first value will be " testing ",
then " 456 "
then " 567 "

Thanks for the help. My main problem was just getting the Trim() method to work and I figured that out.