Text to Columns Question

From: XXdennismu@xxxxxxxxxxxx rm the XX's (Dennis)
Date: Thu, 29 Dec 2005 18:49:16 GMT

I have 6 fields of data all in column A but each row the data is spaced out
differently, not even close. The fields themselves do not have any spaces but
obviously there various spacing beteen the fields. The first feild is flush
left but all the others are all over the map. Is there a way I can prepare the
data so it's sumwhat lined lined up enough to get a accurate Text to Columns
without hacking off some text in some rows? It's 17k+ rows.

TIA Dennis
==============
.

Follow-Ups:
- Re: Text to Columns Question
  - From: Ron Rosenfeld

Prev by Date: Re: How do I keep multi-subtotals in the same order within the report
Next by Date: Re: formula for negative and positive numbers in different columns
Previous by thread: Re: How do I keep multi-subtotals in the same order within the report
Next by thread: Re: Text to Columns Question
Index(es):
- Date
- Thread

Relevant Pages

Re: Text to Columns Question
... The first feild is flush ... >left but all the others are all over the map. ... >without hacking off some text in some rows? ... >TIA Dennis ...
(microsoft.public.excel.worksheet.functions)
[PATCH 2/7] fs/ext{2,3,4}: Use BUG_ON
... prev = rsv; ... printk("Window map complete.\n"); ... #define rsv_window_dump(root, verbose) \ ...
(Linux-Kernel)
Field for sequence of bits
... prefer to have one field and then map the content into a structure with 12 ... integers (using lset). ... Diane ... Prev by Date: ...
(microsoft.public.access.tablesdbdesign)
Re: BtsAsmExt.DLL Missing
... quickly look at a schema or map in IE in XML view:) ... Tomas Restrepo ... Prev by Date: ...
(microsoft.public.biztalk.general)
running external Dos commands or programs
... I have come up with a problem which I can't seem to be able to resolve. ... want to be able to map a drive but haven't been able to get the ... Brian ... Prev by Date: ...
(microsoft.public.dotnet.vjsharp)