View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells

Frank

Maybe you could work with DataText to ColumnsDelimited by space.


Gord Dibben MS Excel MVP

On Tue, 18 Dec 2007 01:21:00 -0800, Frank Situmorang
wrote:

Thank you Gary, I will give a try