Excel formula/macro for extracting specific text
- or -
Post a project like this£35(approx. $44)
- Posted:
- Proposals: 30
- Remote
- #2159870
- Expired
Excel, Formulas, VBA Programming, Data Cleaning, Translations (English - Portuguese)
Sao Pedro da Aldeia
239315922197212247736234796823561412367525237779723907392405812240462724039792416305
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