In Progress

Excel Sheet Fix Via Macro

I have an excel sheet that has 1 column of data in the attached .TXT file. I need that one column split into 6 columns. There are 15,558 lines of data that I need this done for.

I'm hoping there is an excel wizard out there that can create a quick MACRO to make this happen in minutes, instead of the hours that would be necessary for manually cutting and pasting.

Attached is a sample excel file where I have already split the first 5 rows of data up into the 6 columns to show you what needs to be done.

Please be realistic on how long it will take you to finish the job. Don't enter 1 day if you know it will take you 5.

Looking forward to your bid.

Skills: Data Entry, Data Processing, Excel

See more: you fix it, how fix it, excel macro how to, data entry macro, fix macro excel, what is macro in excel, excel split columns, 1.5 hours in minutes, sheet, macro, macro excel, macro + excel, fix excel macro, EXCEL SHEET , excel sheet an, quick excel, sheet excel job, excel macro txt, excel split sheet, fix finish, excel split, fix excel, excel file columns, excel sample file, excel create macro

About the Employer:
( 64 reviews ) DURHAM, United States

Project ID: #942862

Awarded to:


Hi nanovation, please see PM for details.

$49 USD in 2 days
(11 Reviews)

8 freelancers are bidding on average $85 for this job


Lets start, please send me the file.

$80 USD in 3 days
(218 Reviews)

Pls Check PM

$50 USD in 0 days
(221 Reviews)

Hi, please view my PM, thanks.

$150 USD in 2 days
(107 Reviews)

I did some work for you several days back.

$50 USD in 1 day
(28 Reviews)

Hi, I can deliver a solution within 24hrs based on the txt file given & will ensure a robust solution for future datasets (including support / modifications for future requirements where appropriate)

$100 USD in 1 day
(1 Review)

__________________please your PMB_________________________

$100 USD in 3 days
(0 Reviews)

There is unknown rule between Owner's Name and Legal Description separations, so this part is hard (impossible?) to do with macro/VBA code. Other parts are OK, but the one I described here.

$100 USD in 1 day
(0 Reviews)