Does Excel 2002 allow splitting a cell? I have been asked that
question, and I cannot find the answer on this site. Maybe one of you
can help.
Thanks,
Don


--
DonDavis
------------------------------------------------------------------------
DonDavis's Profile: http://www.excelforum.com/member.php...o&userid=27767
View this thread: http://www.excelforum.com/showthread...hreadid=472766

Hello DonDavis,

Depends on what you mean by 'splitting a cell'. This can be taken a few
ways. There are some functions which you can use that will look at a cell
and show specific (as directed by character number/locations) parts of a
cell and show them. These are LEFT, MID and RIGHT functions. A way to
actually take what's in a cell and split it into various columns, there is
also the Text to Columns feature, found under the Data menu.

Not sure what else to tell you as I'm unsure what else you need.

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)


"DonDavis" <(E-Mail Removed)> wrote in
message news(E-Mail Removed)...
>
> Does Excel 2002 allow splitting a cell? I have been asked that
> question, and I cannot find the answer on this site. Maybe one of you
> can help.
> Thanks,
> Don
>
>
> --
> DonDavis
> ------------------------------------------------------------------------
> DonDavis's Profile:
> http://www.excelforum.com/member.php...o&userid=27767
> View this thread: http://www.excelforum.com/showthread...hreadid=472766
>

I think Don wants to split the cell so that it becomes two table cells
like in MS Word. In Excel you cannot split cells within cells or create
another table within a cell. To get the same effect you must insert
a whole column then except for your two adjacent cell, merge all the
other cells in the column (row by row).
Merge and Unmerge Cells
http://www.mvps.org/dmcritchie/excel/merge.htm

Merged cells interfere with sorting and adjusting cell width and height
so they are much more useful in simulating forms than in working
as a spreadsheet where you typically insert rows and columns.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Zack Barresse" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> Hello DonDavis,
>
> Depends on what you mean by 'splitting a cell'. This can be taken a few
> ways. There are some functions which you can use that will look at a cell
> and show specific (as directed by character number/locations) parts of a
> cell and show them. These are LEFT, MID and RIGHT functions. A way to
> actually take what's in a cell and split it into various columns, there is
> also the Text to Columns feature, found under the Data menu.
>
> Not sure what else to tell you as I'm unsure what else you need.
>
> --
> Regards,
> Zack Barresse, aka firefytr, (GT = TFS FF Zack)
>
>
> "DonDavis" <(E-Mail Removed)> wrote in
> message news(E-Mail Removed)...
> >
> > Does Excel 2002 allow splitting a cell? I have been asked that
> > question, and I cannot find the answer on this site. Maybe one of you
> > can help.