{I edited my note b/c of the way it was displayed. pretend each of the periods in quotes below are really spaces.}
I imported a text file, and want to split it up into columns. It is all in column A right now. I want to insert a "column break" if two spaces are encountered. i.e., if column A = "abc...def.gh......ijk" then I would have "abc" in b1, "def.gh" in c1, and "ijk" in d1.
I have tried one method: in b1, i type =find("..",$a1,1) and in c1 i type =find("..",$a1,b1+1) and then fill right for several columns. Then I can use left and right functions to do the rest. This works fine, except if I have several spaces in a row: I want this to mean a single column break. But in my method, it would detect each set of two spaces independently. (i.e. if there were five spaces in a row, it would indicate 4 column breaks). I couldn't figure out how to maniuplate the find function to get around that.
Any ideas? Thanks in advance.
This message was edited by tk19 on 2002-04-11 14:02
This message was edited by tk19 on 2002-04-12 11:51
I imported a text file, and want to split it up into columns. It is all in column A right now. I want to insert a "column break" if two spaces are encountered. i.e., if column A = "abc...def.gh......ijk" then I would have "abc" in b1, "def.gh" in c1, and "ijk" in d1.
I have tried one method: in b1, i type =find("..",$a1,1) and in c1 i type =find("..",$a1,b1+1) and then fill right for several columns. Then I can use left and right functions to do the rest. This works fine, except if I have several spaces in a row: I want this to mean a single column break. But in my method, it would detect each set of two spaces independently. (i.e. if there were five spaces in a row, it would indicate 4 column breaks). I couldn't figure out how to maniuplate the find function to get around that.
Any ideas? Thanks in advance.
This message was edited by tk19 on 2002-04-11 14:02
This message was edited by tk19 on 2002-04-12 11:51