Excel assistance
2485
$
- Posted:
- Proposals: 14
- Remote
- #1598482
- Archived
Excel Expert, Excel Spreadsheets, Excel VBA & Access Database Developer, Data modelling & Analysis
London
PHP, Wordpress, Drupal, Magento, Data Entry, Administrative and Technical Support, SEO, Digital Marketing
Kingston
Web Designer (Front End Developer) | Content Management | Data Entry | Virtual Assistant
Mandaluyong City
Spreadsheets and Databases Development, Data Mining, Development (VBA, Visual Basic, SQL), Finance, Financial Markets
Denny
4205419032731556135147074947989348311693051384864141241214140071467017
Description
Experience Level: Entry
General information for the business: not applicable
Description of excel work: Hi,
I have a report i will be dumping into excel on a regular basis and i need to extrapolate some data from this dump in an automated way so when i dump the new date in to the data dump tab the data is processed by formulas in the new tab to the format i need.
I have taken this data and put it in a new spreadsheet to share once proposals are received.
I have no problem with additional (hidden) columns being created.
so one of my columns contains e.g. "Total: 4232" however i need to remove the "Total: " element just to leave the number. This number ranges from 0 to around 100,000 therefore the number of digits makes using the right funtion unsuitable. Column A, can either be converted into the same column or added into column b)
Secondly another field contains 3 sets of data seperated by a "-" and i need to put each piece of data in its own cell. eg 13 - 264 - 2085 would need to become "13" "264" "2085" across three columns
(Column C currently but needs splitting into Columns d. E & F)
Design and target audience: internal use only
Extra notes: needs to be able to work on new data on a weekly basis on a work network.
Description of excel work: Hi,
I have a report i will be dumping into excel on a regular basis and i need to extrapolate some data from this dump in an automated way so when i dump the new date in to the data dump tab the data is processed by formulas in the new tab to the format i need.
I have taken this data and put it in a new spreadsheet to share once proposals are received.
I have no problem with additional (hidden) columns being created.
so one of my columns contains e.g. "Total: 4232" however i need to remove the "Total: " element just to leave the number. This number ranges from 0 to around 100,000 therefore the number of digits makes using the right funtion unsuitable. Column A, can either be converted into the same column or added into column b)
Secondly another field contains 3 sets of data seperated by a "-" and i need to put each piece of data in its own cell. eg 13 - 264 - 2085 would need to become "13" "264" "2085" across three columns
(Column C currently but needs splitting into Columns d. E & F)
Design and target audience: internal use only
Extra notes: needs to be able to work on new data on a weekly basis on a work network.
Cecilia D.
100% (12)Projects Completed
22
Freelancers worked with
20
Projects awarded
63%
Last project
21 Dec 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Morning Cecilia,
I have submitted a proposal but am running out of time for today. I would really like to assist you on this occasion as I feel it would be beneficial to you.
I would be grateful if you could respond shortly with your intention.
Regards
Tony H -
Good Morning,
Could you provide a spreadsheet with sample data demonstrating before and after results.
Thanks
434530434391
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