Text to columns

I'm looking for a way of duplicating Excels Text-to-columns function. Is there one?

I have (variable length) data which is space separated and I know the number of columns. I had a quick look at the string functions, but could not find a quick way of getting the n:th occurence of a character from a string. With the indexes I could take substrings from the source string.