ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I splti cells? (https://www.excelbanter.com/excel-discussion-misc-queries/193570-how-do-i-splti-cells.html)

Blonde Moment

How do I splti cells?
 
I am trying to split 1 cell down into 2 or more cells but cant remember how
to do it.

Per Jessen

How do I splti cells?
 
Maybe TextToColumns ?

Regards,
Per

"Blonde Moment" <Blonde skrev i
meddelelsen ...
I am trying to split 1 cell down into 2 or more cells but cant remember how
to do it.



FSt1

How do I splti cells?
 
hi
have your tried text to columns
on the menu bar....
datatext to columnfollow the wizard.

regards
FSt1

"Blonde Moment" wrote:

I am trying to split 1 cell down into 2 or more cells but cant remember how
to do it.


Lorne[_2_]

How do I splti cells?
 
"Blonde Moment" <Blonde wrote in message
...
I am trying to split 1 cell down into 2 or more cells but cant remember how
to do it.


You can merge 2 or more cells into one (select the cells to merge and right
click to bring up a menu with the option) and the same menu has an option to
unmerge (ie return the double cell into 2 single ones), but I do not think
you can split a single cell that has not been previously merged.



Bob I

How do I splti cells?
 
If you actually want an additional empty cell, click the location, then
Insert, Cells

Blonde Moment wrote:
I am trying to split 1 cell down into 2 or more cells but cant remember how
to do it.




All times are GMT +1. The time now is 02:12 AM.

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