View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default to split the cell containt

Look at Data=Text to Columns.

"anil" wrote:

hi all,

I have a column with 100 enteries....the entries are as "abc sdf sdsd"
here i would like to copy tthis cell entities in to next three cells
by spliting at space between two words