How to split a cell in Excel?
In word you can right click on a cell in a table and then split it into a
number of cells, without disturbing the surrounding cells of the origininal cell. Is there a way of doing the same thing in Excel? |
How to split a cell in Excel?
Nope. You can merge, but not split.
"Benz_UK" wrote: In word you can right click on a cell in a table and then split it into a number of cells, without disturbing the surrounding cells of the origininal cell. Is there a way of doing the same thing in Excel? |
How to split a cell in Excel?
That's not true...you can split information in EXCEL apart...
you can Use Text to Columns to split contents of a cell out based on either fixed length or delimited based on criteria you select such as spaces or commas. You can also split information apart using the LEFT, RIGHT functions... -- Ted "Benz_UK" wrote: In word you can right click on a cell in a table and then split it into a number of cells, without disturbing the surrounding cells of the origininal cell. Is there a way of doing the same thing in Excel? |
How to split a cell in Excel?
You will need "empty" cells to the left or right of the column you want to split or they will be overwritten when you split, (i.e. if you split 1 column into 3 - you need 3 empty cells. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=520063 |
All times are GMT +1. The time now is 07:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com