Create formulas for Google Sheets and remove unnecessary text.
The table contains about 300 product description texts. These texts will be uploaded to a Shopify-based website. And they must immediately have the correct header sizes in HTML format.
Task checklist:
1. Remove all text that is STRIKETHROUGH in red;
2. Remove all "Call to Action" header titles, but keep the descriptions below them;
3. Remove "Sources" headers and all links below them;
5. Remove the characters "###" and "**" from all texts;
4. Create a formula in Google Sheets (or formulas) that automatically assigns h5 size to headers. To do this, each header should be highlighted like this: <h5> Header </h5>
Below I am attaching the table. Please work with it in Google Sheets.
These tasks must be completed by Wednesday at 11:00.
If you have any additional questions, I will be happy to answer. If you know a better way to solve the tasks, please share your ideas.
Applications 1
-
148 1 0 Hello, I have experience working with Google Docs. I am ready to complete the task. I look forward to collaborating.
-
688 10 0 Hello, I am ready to start working on it now. It will be ready by the specified time. If we can discuss a few details? I would appreciate it.