View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Converting Tab Delimited Text File to A Comma Delimited Text File

How does changing the delimiter affect the number of columns in that row?



wrote:

I have a situation where I need to convert a tab delimited text file
to a comma delimited text file.
It would be an easy process but the number of colums to be imported
into excel exceeds MS Excel's 256 column limit.

I would appreciate any help that you could provide me.

The data is currently in the format below:

1234 45676 4332.23212 23334.21 with the spaces in between the
numbers being tab spaces.
I would like to convert it to the format below:
1234,45676,4332.23212,23334.21
And then to be able to input each number into a separate column.

Thanks in Advance,

Kwesi


--

Dave Peterson