Simple Excel Macro
- or -
Post a project like this2428
£25(approx. $31)
- Posted:
- Proposals: 4
- Remote
- #1677234
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Description of excel work: Our supplier sends us descriptions for products and the description as a whole is in one cell for each item. Cell A in the example sheet shows this.
We need to split the description up into 5 points, so each point goes in a separate cell (Columns B to F) in the spreadsheet.
Each point in the description is seperated by a hyphen which you can also see in the example.
The macro needs to be able to deal with up to 5000 rows of data
Should any cell in column A contain the phrase '#NAME?' then it should not put anything into the 'point cells'
Extra notes:
The info that goes into the columns titles Point 1 , Point 2 etc should start with a capital letter please
We need to split the description up into 5 points, so each point goes in a separate cell (Columns B to F) in the spreadsheet.
Each point in the description is seperated by a hyphen which you can also see in the example.
The macro needs to be able to deal with up to 5000 rows of data
Should any cell in column A contain the phrase '#NAME?' then it should not put anything into the 'point cells'
Extra notes:
The info that goes into the columns titles Point 1 , Point 2 etc should start with a capital letter please
Steve J.
100% (50)Projects Completed
57
Freelancers worked with
47
Projects awarded
84%
Last project
27 Feb 2020
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
I notice that some descriptions have more than 5 points, how are additional points going to be dealt with?
481643
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