View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.programming
Frank Situmorang[_2_] Frank Situmorang[_2_] is offline
external usenet poster
 
Posts: 65
Default how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells

Thanks very much Gord, you gave me a simple way.

--
H. Frank Situmorang


"Gord Dibben" wrote:

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