ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I merge one cell into two cells? (https://www.excelbanter.com/excel-discussion-misc-queries/91234-how-do-i-merge-one-cell-into-two-cells.html)

auntieboop

How do I merge one cell into two cells?
 
I have one row which I'm trying to convert to 2 cells. I use alignment, merge
cells. But it's not working. I tried wrap & merge & still isn't working. What
am I doing wrong? Thank you

Ron Coderre

How do I merge one cell into two cells?
 
MERGE converts multiple cells into one cell

I think you may want to check this:

From the Excel main menu:
<data<text-to-columns

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"auntieboop" wrote:

I have one row which I'm trying to convert to 2 cells. I use alignment, merge
cells. But it's not working. I tried wrap & merge & still isn't working. What
am I doing wrong? Thank you



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

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