Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Split one cell into 4 cells without adding columns?

I don't think this is possible - asking for a friend. Can you split one cell
into 4 cells without adding any other columns?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Split one cell into 4 cells without adding columns?

Do you mean that data from cell A1, for example, should be split into A2,
A3, A4 and A5 ?

Give us some examples of what data you have and how you want it to be split.

Pete

"Spankie1" wrote in message
...
I don't think this is possible - asking for a friend. Can you split one
cell
into 4 cells without adding any other columns?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Split one cell into 4 cells without adding columns?

Nope.

But you could combine 4 cells into one by merging it. Then the cells that
aren't merged would look like they've been split.

Be aware that merged cells can really screw up other things--sorting,
copy|pasting, filtering, ...

Spankie1 wrote:

I don't think this is possible - asking for a friend. Can you split one cell
into 4 cells without adding any other columns?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I turn 1 cell into 2 cells without adding columns or rows? Shawna Excel Discussion (Misc queries) 2 May 30th 08 10:34 PM
Split Cell Across Two Columns CCarter Excel Discussion (Misc queries) 10 February 24th 08 01:28 PM
How to split columns with multiple lines w/in cells Ben Excel Discussion (Misc queries) 2 May 30th 07 03:52 PM
Can I split a excel cell w/out adding a column? Cheryl Excel Discussion (Misc queries) 1 April 19th 06 04:22 PM
How do I split a cell into multiple rows/columns? SKA Excel Discussion (Misc queries) 1 January 18th 06 12:04 AM


All times are GMT +1. The time now is 03:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"