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.

Evner: Dataindførsel, Databehandling, Excel

Se mere: 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

Om arbejdsgiveren:
( 64 bedømmelser ) DURHAM, United States

Projekt ID: #942862

Tildelt til:


Hi nanovation, please see PM for details.

$49 USD in 2 dage
(11 bedømmelser)

8 freelancere byder i gennemsnit $85 på dette job


Lets start, please send me the file.

$80 USD in 3 dage
(218 bedømmelser)

Pls Check PM

$50 USD in 0 dage
(221 bedømmelser)

Hi, please view my PM, thanks.

$150 USD in 2 dage
(107 bedømmelser)

I did some work for you several days back.

$50 USD på 1 dag
(28 bedømmelser)

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 på 1 dag
(1 bedømmelse)

__________________please your PMB_________________________

$100 USD in 3 dage
(0 bedømmelser)

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 på 1 dag
(0 bedømmelser)