Need Data Extracted From an Excel Worksheet
3438
$$
- Posted:
- Proposals: 10
- Remote
- #614950
- Archived
Email Findings, Lead generation , Contact Building , LinkedIn Prospecting, Data Gathering & Processing, Products upload to Online platforms Such as Amazon, eBay, Etsy & Shopify.
Hyderabad
9574598984487463515826565900573552679167739889756393778101
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Analysis tool: Excel
Description of analysis: I have an excel spreadsheet with approximately 1200, single cell rows. I need to extract the dimensional data from each one and place it in separate columns.
Here is one example:
"Length (e.g. 24.50 or 24 1/2): 24 Inches, Height (e.g. 24.50 or 24 1/2): 18 1/4 Inches, Brushed Finish Grain Direction Preference: lengthwise, Popular Options: hemmed lengthwise, custom cutout (outlets, profile, etc), Upload Your Measurements."
Need to extract "24" and "18 1/4", and place the numbers in separate columns.
Another example from the same sheet:
"Width (Inches: E.g 24, 24.50 or 24 1/2): 38, Height (Inches: E.g 24, 24.50 or 24 1/2): 38, Pattern Direction Preference: widthwise, Popular Options: Hemmed Widthwise, Hemmed Heightwise"
Need to extract the "38" and "38" into columns.
Width and length have been used interchangeably. When finished there should be 2 columns, titled respectively, Width (inches), Height (Inches).
Ideally, I would like the formulas included in this so I can repeat the procedure.
Extra notes:
Description of analysis: I have an excel spreadsheet with approximately 1200, single cell rows. I need to extract the dimensional data from each one and place it in separate columns.
Here is one example:
"Length (e.g. 24.50 or 24 1/2): 24 Inches, Height (e.g. 24.50 or 24 1/2): 18 1/4 Inches, Brushed Finish Grain Direction Preference: lengthwise, Popular Options: hemmed lengthwise, custom cutout (outlets, profile, etc), Upload Your Measurements."
Need to extract "24" and "18 1/4", and place the numbers in separate columns.
Another example from the same sheet:
"Width (Inches: E.g 24, 24.50 or 24 1/2): 38, Height (Inches: E.g 24, 24.50 or 24 1/2): 38, Pattern Direction Preference: widthwise, Popular Options: Hemmed Widthwise, Hemmed Heightwise"
Need to extract the "38" and "38" into columns.
Width and length have been used interchangeably. When finished there should be 2 columns, titled respectively, Width (inches), Height (Inches).
Ideally, I would like the formulas included in this so I can repeat the procedure.
Extra notes:
PPH User P.
100% (11)Projects Completed
7
Freelancers worked with
7
Projects awarded
10%
Last project
4 Jan 2017
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies