I have a field with mixed numbers and text (i.e. 232.4Ft). I want to strip of
the unit of measure (i.e. Ft) and have one field with the number and another
with the unit of measure. Can this be done? I am fairly confident I could do
it in VB, but I am not sure how at this point. Is there a worksheet function?

Thanks in advance!

Kevin