software

IncExcel, how do I create multiple columns within one column? I have a block
of rows within one column and I need to create at least two columns. Is it
possible?

Suppose the data is in A1:A100
Move to A51, select A51:A100 with mouse, use copy; move to b1 and use Paste

Or do you have data like this
John Smith
and you want John in one cell, Smith in another?
If so experiment with he Data|Text to columns feature

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Jeannequot; gt; wrote in message
...
gt; IncExcel, how do I create multiple columns within one column? I have a
gt; block
gt; of rows within one column and I need to create at least two columns. Is
gt; it
gt; possible?
Thank you for responding. The data I have is for example: Fees
#/mo.

$40 5

5 3

etc. in B12-14, and I would like to break up the Fees into one column and
#/mo. in another without disturbing the original B column.

quot;Bernard Liengmequot; wrote:

gt; Suppose the data is in A1:A100
gt; Move to A51, select A51:A100 with mouse, use copy; move to b1 and use Paste
gt;
gt; Or do you have data like this
gt; John Smith
gt; and you want John in one cell, Smith in another?
gt; If so experiment with he Data|Text to columns feature
gt;
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Jeannequot; gt; wrote in message
gt; ...
gt; gt; IncExcel, how do I create multiple columns within one column? I have a
gt; gt; block
gt; gt; of rows within one column and I need to create at least two columns. Is
gt; gt; it
gt; gt; possible?
gt;
gt;
gt;

You need to select the whole column of data; use menu command Data |Text to
Columns;
I would use delimited by size - drag the diving line to the correct place;
it that does not work try by spaces
One problem might arise: the numbers may end up as text. We can fix that
later.
Let us know if you are able to break the data into two columns
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Jeannequot; gt; wrote in message
news
gt; Thank you for responding. The data I have is for example: Fees
gt; #/mo.
gt;
gt; $40 5
gt;
gt; 5 3
gt;
gt; etc. in B12-14, and I would like to break up the Fees into one column and
gt; #/mo. in another without disturbing the original B column.
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; Suppose the data is in A1:A100
gt;gt; Move to A51, select A51:A100 with mouse, use copy; move to b1 and use
gt;gt; Paste
gt;gt;
gt;gt; Or do you have data like this
gt;gt; John Smith
gt;gt; and you want John in one cell, Smith in another?
gt;gt; If so experiment with he Data|Text to columns feature
gt;gt;
gt;gt; best wishes
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;Jeannequot; gt; wrote in message
gt;gt; ...
gt;gt; gt; IncExcel, how do I create multiple columns within one column? I have a
gt;gt; gt; block
gt;gt; gt; of rows within one column and I need to create at least two columns.
gt;gt; gt; Is
gt;gt; gt; it
gt;gt; gt; possible?
gt;gt;
gt;gt;
gt;gt;