Parse Data from Excel Column and Create 2 New Columns

Lukket

Beskrivelse

We have a spreadsheet approximately 20K Rows. Attached is the list of what needs to be parsed and added to the Columns Manufacturer and Model. I did the First few so you see what i want.

We need someone to Parse the Description and create a MFG and Part number column from the Title.

Titles look like this

FuturePlus Systems Hub Interface Analysis System Probe FS2225

I would expect the MFG to be as FuturePlus Systems and the Model is FS2225

Electroglas Wafer Prober 1031 w/ Olympus Microscope Head

MFG: Electroglas Part Number 1031

I-TECH Model IFC-4016-04E, Fibre Channel Analysis System, Finisar FCM-8519-2-T-4

MFG: I-TECH Model: IFC-4016-04E

Marathon Electric TQA56A34F7A 115/230V 1/3 HP 3450 RPM 1 Phase Motor 151-015-12

MFG: Marathon Electric Model TQA56A34F7A

Færdigheder: Dataindførsel, Excel

Se mere: create 150k data excel, column data excel, separate data excel rows column columns, create sticker data excel, create save data excel file php script, create sheets excel column data vba, output column data excel macro, create write data excel file using dataset, convert multiple columns single column excel, create graph csv data excel, can create simple data input macro excel 2007, copy column selected data excel macro, data selected parse excel, parse html data excel

Projekt-ID: #13800443

28 freelancere byder i gennemsnit $128 for dette job

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Mere

$100 USD in 3 dage
(141 bedømmelser)
6.5
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Data of Multiple Sheets and Parsing Data into different fi Mere

$120 USD in 3 dage
(47 bedømmelser)
4.7
$153 USD in 3 dage
(8 bedømmelser)
3.9
orugantn

Hello, I am good with Excel and I can complete with using regex methology. Since you do not have single type or configuration to distinct part number, I will use machine learning principles to extract the PN and MFG Mere

$166 USD in 3 dage
(4 bedømmelser)
3.7
$74 USD in 3 dage
(2 bedømmelser)
1.7
WebsGenius

A proposal has not yet been provided

$150 USD in 5 dage
(2 bedømmelser)
1.4
brittanybeckner

A proposal has not yet been provided

$250 USD in 15 dage
(1 bedømmelse)
0.8
Deji88

Dear Esteemed Client, I am readily available to assist you with this data entry project. I deliver top-quality work on time.

$155 USD in 3 dage
(1 bedømmelse)
0.9
Ahide

Hi, I'm a computer systems engineer, expert in excel! These are some of my achievements using excel when I was an employee for big companies like Camelbak & Jawbone: *Design and Development of a Tool for productio Mere

$133 USD in 3 dage
(0 bedømmelser)
0.0
altamanvw

Hello. I have done a lot of parsing of large and complete data sets for financial and tech companies. This is not a very complex task from the examples you have given and I have the necessary logic already. I wil Mere

$75 USD in 2 dage
(0 bedømmelser)
0.0
shobhacodeguru

I have addressed these kind of projects before. This can be handled through programming to auto fill the columns based on the parsing of necessary information. Will be using Excel Macros and VBA for implementing the Mere

$66 USD in 5 dage
(0 bedømmelser)
0.0
ThatDataEntryGuy

This project sounds too good to be true! I do this type of data entry every single day! From your example, I completely understand what you want and I know I can do it. I am new to Freelancer, but not new to this t Mere

$68 USD in 5 dage
(0 bedømmelser)
0.0
AsileShakaa

A proposal has not yet been provided

$155 USD in 3 dage
(0 bedømmelser)
0.0
KaiFH

Qualified Chartered Accountant, Ex-Big Four External Audit, Currently Working in Commercial Finance in Top ASX listed company.

$111 USD in 3 dage
(0 bedømmelser)
0.0
VMallow

A proposal has not yet been provided

$75 USD in 3 dage
(0 bedømmelser)
0.0
florangelmillan

My proposal is to incorporate a column that extracts the necessary characters and concatenates them with the model of the equipment. I have experience in data management in excel since as project controller of massive Mere

$100 USD in 2 dage
(0 bedømmelser)
0.0
pablomerayo1

I have a lot of experience working with Excel files and I can do the work well and quickly. It will be a garanty to give me the work. You can contact to me by facebook (Pablo Santos Merayo), mail or by phone/whatsapp Mere

$111 USD in 3 dage
(0 bedømmelser)
0.0
Hfighter

Dear customer I'm really interested to do you project. I know you prefer to work with experience freelancer. But Me too worked about 10 year with excel in a private university. Let me do it. thanks

$100 USD in 4 dage
(0 bedømmelser)
0.0
Solnb37

A proposal has not yet been provided

$166 USD in 3 dage
(0 bedømmelser)
0.0
ryanriley5

I am extremely hard working and am very proficient with excel and other database spreadsheets. I am working towards building my career, and would be willing to work for much less than other people. I ask that you pleas Mere

$111 USD in 10 dage
(0 bedømmelser)
0.0