ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Split one cell into 4 cells without adding columns? (https://www.excelbanter.com/excel-discussion-misc-queries/208846-split-one-cell-into-4-cells-without-adding-columns.html)

Spankie1

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?

Pete_UK

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?




Dave Peterson

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


All times are GMT +1. The time now is 04:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com