How to split a cell in Excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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...
 
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.
 
Back
Top