markgriffith
New Member
- Joined
- Sep 1, 2002
- Messages
- 2
Please forgive me if this is a stupidly simple question.
I want to paste large bodies of text either into columns or rows such that I get one word per cell. I see that there is an existing option under 'data' / 'text to columns' which allows this if I go through and click each proposed column-break manually, but I want this to be automated.
If I had a list like this:
1 house 2 tree 3 dog
I would like to either have a 3-cell row reading
<1 house> <2 tree> <3 dog> or a 3-cell column reading
<1 house> <2 tree> <3 dog>. Of course, the actual list will have hundreds of words in it, so I want to avoid manually marking the column/row breaks.
Is there an easy way to do this?
Many thanks! Mark Griffith
http://www.otherlanguages.org
I want to paste large bodies of text either into columns or rows such that I get one word per cell. I see that there is an existing option under 'data' / 'text to columns' which allows this if I go through and click each proposed column-break manually, but I want this to be automated.
If I had a list like this:
1 house 2 tree 3 dog
I would like to either have a 3-cell row reading
<1 house> <2 tree> <3 dog> or a 3-cell column reading
<1 house> <2 tree> <3 dog>. Of course, the actual list will have hundreds of words in it, so I want to avoid manually marking the column/row breaks.
Is there an easy way to do this?
Many thanks! Mark Griffith
http://www.otherlanguages.org