176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Separate items in a spreadsheet
Sign in to Add to Watch List

Admin Support > Data Entry

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Sat, Aug 11, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

Attached text file is designed to be imported into a spreadsheet. The spreadsheet has 2522 rows of keywords. Approximately half have a location associated with them (Utah, New York City, San Francisco, etc) I want all the unique locations separated from the non-location-specific keywords and put together.
Here is how to do it. Column A (Ad Group) contain numerous locations (Utah, Montana, etc). Separate those out into separate groups (at the bottom of the spreadsheet). That is just cut and paste.
Then in Column B look at each keyword. Embedded in many of them (particularly the ones in the bottom half of the rows) is a location code. These are US-based searches and the people are using 2-letter designations for the US states or cities.(MD= Maryland, MT=Montana, SF=San Francisco) or 3-letter designations for cities (NYC=New York City) or in some cases the entire name of the state (Hawaii, for instance). Separate out each of those into a unique group at the bottom of the spreadsheet....

Sign in or Register to see more

Job ID: 32659097
 
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
I am a doctoral candidate in economics at the University of Houston. I have extensive experience doing economic research which includes modeling,...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32669945  |  Submitted: Aug 12, 2012 02:59 ET 
Proposal SEALED

 New Zealand  |  
I am a software professional with over 5 years of experience in Java/J2EE. I am very honest, smart working and deliver high quality service on time.
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32669441  |  Submitted: Aug 12, 2012 02:02 ET 
Proposal SEALED

 India  |  
My name is Ajay Kumar. I have post degree in Computer Applications.I have more than 3 years of experience in Data Handling.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32669192  |  Submitted: Aug 12, 2012 01:30 ET 
Proposal SEALED

 United States  |  
I have 25 years of experience with personal computers and I have the time to do the menial data manipulation tasks that you do not. My expertise is...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32668861  |  Submitted: Aug 12, 2012 00:54 ET 
Proposal SEALED

 United States
I am an honest hard working professional. I am very proficient in Excel, Word, etc. I work hard to ensure my tasks are completed on time, every...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32667107  |  Submitted: Aug 11, 2012 21:15 ET 
Proposal SEALED

 United Kingdom  |  
All sorts of Engineering projects can be done over here with highly professionalized manner and can be done under highly qualified persons.All...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32666441  |  Submitted: Aug 11, 2012 19:49 ET 
Proposal SEALED

 United Kingdom  |  
Specialised online Data Entry Jobs
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32666317  |  Submitted: Aug 11, 2012 19:33 ET 
Proposal SEALED

 Bangladesh
I am an exceedingly hard-working and dedicated human being. Apart from this I am also versatile and love to handle new challenges that life throws...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32665867  |  Submitted: Aug 11, 2012 18:30 ET 
Proposal SEALED

 United States  |  
INVITED
I have over 24 years of experience in a variety of disciplines from project management and online research to marketing strategies and event...
3
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32665790  |  Submitted: Aug 11, 2012 18:19 ET 
Proposal SEALED

 United States  |  
I am a computer teacher in Texas who has taught students how to use MS Office, Internet usage, and can help you complete your data entry projects!
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32665342  |  Submitted: Aug 11, 2012 17:26 ET 
Proposal SEALED

 United States
Highly focused, result oriented, detail- oriented professional seeking to use my strong IT skills and talents into jobs. I never missed deadlines &...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 32663789  |  Submitted: Aug 11, 2012 15:17 ET 
Proposal SEALED

 Croatia (Hrvatska)  |  
Hard working, accurate, on-time, dedicated to work. Experienced in MS Office tools especially Word and Excel.
8
  |  
 5.0   |  Private   |  13 Jobs
Bid ID: 32663511  |  Submitted: Aug 11, 2012 14:59 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choise of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »