Excel formula/macro for extracting specific text
- or -
Post a project like this£35(approx. $44)
- Posted:
- Proposals: 30
- Remote
- #2159870
- Expired
Virtual Assistant, Excel programmer, Customer Support Agent, EN-GR/GR-EN Translator
Kornos
Data scraping / data mining / data extraction / web scraping / scraping / data conversion / General admin support and more
Kent
879962745411649865486495139058128156
Description
Experience Level: Entry
I have thousands of rows of data which contains attendance from different schools. However, the format which our data is being stored makes it very hard to extract the information I need directly from our database.
Therefore, I'm looking for an excel formula/macro which can extract specific strings (Please refer to example data from here onwards):
At every iteration of "School:" the following text afterwards before the "," needs to be extracted.
Each row has a different amount of schools included, therefore the formula/macro needs to be dynamic in how many school names it can return.
There will never be more than one school name after the "School:" and before the ","
Therefore, I'm looking for an excel formula/macro which can extract specific strings (Please refer to example data from here onwards):
At every iteration of "School:" the following text afterwards before the "," needs to be extracted.
Each row has a different amount of schools included, therefore the formula/macro needs to be dynamic in how many school names it can return.
There will never be more than one school name after the "School:" and before the ","
Guy W.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
33%
Last project
10 Mar 2017
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
what version of MS office you use i can help you
719671
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