View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ted
 
Posts: n/a
Default 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?