How do I split a small group of cells into a number of different column
without affecting the rest of the cells on the sheet? Is this eve
possible?
I have is six rows, and I want to split the first column of all o
these rows into a number of different columns, without affecting th
arrangement of columns above these six rows.
Any help would be greatly appreciated. Thanks
Don Guillett - 18 Jul 2006 18:12 GMT
Have you tried it using data>text to columns?

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
>
> How do I split a small group of cells into a number of different columns
[quoted text clipped - 6 lines]
>
> Any help would be greatly appreciated. Thanks.
csteuart - 18 Jul 2006 18:51 GMT
I tried using data>text to columns but it didn't do what I was trying to
do. Maybe I wasn't using it properly? Or is there some other way?

Signature
csteuart
Ragdyer - 18 Jul 2006 19:07 GMT
WELL ... what are you trying to do?

Signature
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
>
> I tried using data>text to columns but it didn't do what I was trying to
> do. Maybe I wasn't using it properly? Or is there some other way?
Don Guillett - 18 Jul 2006 22:13 GMT
I just selected the cell(s), NOT the rows, that I wanted to split and used
data>text to columns and it worked just fine. An example of your text might
be helpful

Signature
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
>
> I tried using data>text to columns but it didn't do what I was trying to
> do. Maybe I wasn't using it properly? Or is there some other way?
Mike Middleton - 18 Jul 2006 19:35 GMT
csteuart -
From your description, it is not clear to me what you want to do.
However, all cells in a column must have the same width.
- Mike
www.mikemiddleton.com
> How do I split a small group of cells into a number of different columns
> without affecting the rest of the cells on the sheet? Is this even
[quoted text clipped - 5 lines]
>
> Any help would be greatly appreciated. Thanks.