repost: split excel columns

  • Thread starter Thread starter Bryan
  • Start date Start date
B

Bryan

Thank you for the feed back on the below question. When
using "text to columns" it seems to create new columns and
the info. in one column can be split but I was looking to
essentially create two columns in one. For instance,
within column D which was widened, I wanted two columns in
rows 5:15. I'm trying to convert something into an excel
template that is too long and don't want to change any of
the column widths already in place. I know you can do this
in Word when transferring an excel table. You would right
click on the cell and there is a function called split
cells. Thank you!

Subject: Split certain excel columns
From: "Bryan" <[email protected]> Sent: 8/12/2003
7:26:41 AM




Hi, I'm looking to split certain excel cells within a
column into columns but not the entire way down the
spreadsheet. Say for instance, for Column D and rows 5-15
I'd like to have two columns but not extend that beyond
row 15. Is there any functions that would enable me to do
this? Thanks for any help!
 
You may want to use Merged cells.

Select D16:E16 and format|Cells|alignment tab
click on "merge cells"

Be aware that merged cells cause other problems (merged cells in xl97 was a big
problem. But with each version of excel, it's gotten better. (I still try to
stay away from them unless absolutely necessary.))
 
Back
Top