Closed

Convert text to excel

I need someone to write a script that converts a text file into rows of excel. I need you to take each line of text and take the words separated by the "|" in the line and put them into different columns. Here is an example of one of the lines.

0HONG KWANHI|801 N 2ND ST K82|BLYTHEVILLE |AR|72315-2021|ENTERGY ARKANSAS INC|Utility Deposits|10/28/2005|$[url removed, login to view]|10670116

If you are interested in this job, send me a sample of 100 rows so that I can see that you've done it correctly, and also that you're not doing it by hand.

Thanks

Skills: Data Entry, Excel

See more: convert text file excel, entergy, convert write job, arkansas, convert line, excel convert words, excel text rows, write file excel, excel text columns, excel utility, excel rows lines, write script data entry, text convert excel, convert columns text excel, convert excel text, excel data hand, convert text, need someone write text, convert text data, macro convert excel text, convert text data excel, convert excel text file, convert excel columns text, convert columns text, excel convert columns text

About the Employer:
( 0 reviews ) Bangladesh

Project ID: #4371517

25 freelancers are bidding on average $280 for this job

Icebear951

I have to do tasks like this on a regular basis, so I can get this done for you quickly. If you have 100 examples I can create the rows seperated into columns for you today.

$250 USD in 1 day
(2 Reviews)
2.4
srdas2012

Hi,Please check PMB

$250 USD in 7 days
(2 Reviews)
2.1
iainwatson

Hi there, I recognize the format of the text file you're entering, and it isn't necessary to use a script at all - Excel has functionality built-in that can read this kind of file and automatically convert it to an More

$250 USD in 1 day
(1 Review)
1.8
paolocarnelli

For informations please see the private message

$250 USD in 1 day
(1 Review)
1.0
Locust

VBA and text parsing expert here, consider it done. Please provide 100 different lines of text to test my written macro. Thanks.

$250 USD in 0 days
(0 Reviews)
0.0
MilicaS

Hi! With Excel built in function I can do this job easily and very accurate! Do not hesitate to contact me!

$250 USD in 1 day
(0 Reviews)
0.0
amraox

Dear Sir Madam With My Data Entry Experience I have capability to do this project successfully please award the project Best Regards

$315 USD in 4 days
(0 Reviews)
0.0
almirr

I can done this in about 10 mins ! Select me and I will email you the results back today

$250 USD in 0 days
(0 Reviews)
0.0
FreelanceSP

I would be willing to take this job at minimum bid

$275 USD in 1 day
(0 Reviews)
0.0
a711825

I can have this done in about 10 mins ! Select me and I will email you the results back VERY SHORTLY !!! If you want to send me the 100 sample lines I will send them back shortly ! Thanks Gary 0HONG KWANH More

$250 USD in 1 day
(0 Reviews)
0.0
SebaVial

Hello, please read read PM.

$250 USD in 3 days
(0 Reviews)
0.0
neilmiller

PhD Excel expert. Quick turn around.

$250 USD in 1 day
(0 Reviews)
0.0
jamesls59

You can do this task simply using the "Text to Columns" command found in the Data tab of Excel. You merely highlight the cells in one column that you wish to process (insure there are blank columns to the right of the More

$250 USD in 1 day
(0 Reviews)
0.0
vmaxveera

Hi, please PM me with sample... Thanks

$275 USD in 3 days
(0 Reviews)
0.0
CherryInnovators

We can do this job > we are ready

$500 USD in 3 days
(0 Reviews)
0.0
fadyfady022

I can do that for you in 1 day

$330 USD in 1 day
(0 Reviews)
0.0
maniteja009

i can do this...

$250 USD in 2 days
(0 Reviews)
0.0
DataEntryPro48

<<< See Me, Judge Me >>> I have experience to work MS EXCEL "PRACTICALLY". I had been an ACCOUNTANT in KDS Steel Ind. I have VAST knowledge over # MS WORD, # MS EXCEL, # MS POWERPOINT, # ADOBE PHOTOSHOP, # ADOBE ILLUS More

$280 USD in 6 days
(0 Reviews)
0.0
orrjosh

I have this script done already. I will provide you with a professionally engineered script that meets your exact requirements

$250 USD in 1 day
(0 Reviews)
0.0
sudewa

Hi, You dont need a tool. Copy to excel and use text to columns option. Its quick. If you want I can do a script for you. Thanks, Sudewa

$250 USD in 1 day
(0 Reviews)
0.0