Converting Tab Delimited Text File to A Comma Delimited Text File

K

kwesi.acquah

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import a comma delimited file & match records 3
Serial comma delimited text - Import to XL evry 8th comma nuRow 30
copy range to Text (Tab delimited) (*.txt) file 2
Japanese text lost when save as tab delimited text file 0
Open delimited file 3
writing data to a tab delimited text file? 2
Save As xls to text (tab delimited) in encoding utf-8 0
Converting Pipe Delimited Text File To Tab Delimited Text file 5

Top