There's a way, but I need to know whether you want the resulting column to be treated as text or number. I suspect text, but can't be sure.
Try this little experiment where I want to split after 123
When you go splitting, select the column after the vertical line (it'll turn black), then click on Text option. You will end up with
but the stuff ends up as text, so you can't do math on it without conversion.
An alternative would be to insert a ":" or "x" into the strings, and then split on the separator, then remove the separator. However, if numbers result, as they will, your leading zeros will be dropped unless you apply a custom format.
Edited by tos226, 31 March 2011 - 03:42 PM.