View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Disecting Contents

DataText to ColumnsDelimited byCommaNextDestination.

Type in L1 or click on the refedit button and point to L1 then Finish


Gord Dibben MS Excel MVP

On Tue, 29 Apr 2008 09:54:00 -0700, Sandy
wrote:

Hi
I am downloading a file and in column c the contents wil be numeric
separated by commas (as many as 5 numbers separated by commas
12345678,23456789,9876543,123456 in some cases 8 digits and in others 6). I
understand TextColumns for separating the contents however I would like to
keep the downloaded file intact and then disect the contents of Column C into
Column L-P. Suggestions?
Thanks