+ Reply to Thread
Results 1 to 3 of 3

Bulk Text Macro - Require Assistance in seperating each line in HTML

  1. #1
    Registered User
    Join Date
    04-06-2021
    Location
    United Kingdom
    MS-Off Ver
    Excel 2016
    Posts
    1

    Bulk Text Macro - Require Assistance in seperating each line in HTML

    Hi everyone,

    Hope you've all had a wonderful weekend.

    I have received 250 cells which I need to format into HTML for the system I use on my computer for work. Each line/paragraph needs to start with <p> and close with a </p>, however the below macro I have tried using is putting <p></p> in between each paragraph in the space sections. I need this to be gone as the system we use won't accept empty <p></p> lines.

    Is anyone able to assist or fix the below please? Would be much appreciated. Will attach an image of how it looks and the macro I am using.

    Please Login or Register  to view this content.

    Capture.JPG
    Last edited by AliGW; 04-06-2021 at 05:30 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    61,942

    Re: Bulk Text Macro - Require Assistance in seperating each line in HTML

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however you need to include code tags around your code.

    Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

    Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (Note: this change is not optional. As you are new, I have done it for you today.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    20,134

    Re: Bulk Text Macro - Require Assistance in seperating each line in HTML

    Quote Originally Posted by JackBTM View Post
    Each line/paragraph needs to start with <p> and close with a </p>, however the below macro I have tried using is putting <p></p> in between each paragraph in the space sections. I need this to be gone as the system we use won't accept empty <p></p> lines.

    Is anyone able to assist or fix the below please? Would be much appreciated. Will attach an image of how it looks and the macro I am using.
    How do you want it?

    <p>Test test test</P>
    <p>Test test test</P>
    <p>Test test test</P>

    or
    <p>Test test test</P>

    <p>Test test test</P>

    <p>Test test test</P>

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Modify html data in Bulk using Excel
    By cjawadz in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-15-2019, 01:20 AM
  2. [SOLVED] Assistance require to add column 'M' in concatenate
    By mso3 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-12-2016, 04:36 AM
  3. [SOLVED] Macro Assistance - inserting cell & data line by line not by column
    By Toxicca in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-11-2015, 09:26 AM
  4. Require assistance with structure of find macro
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-27-2015, 07:31 PM
  5. Assistance Require with IF, ELSE statement
    By Soulj4h in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-28-2013, 12:08 AM
  6. [SOLVED] Require assistance with Macro for copying cell from one sheet to another.
    By bml-lwilliams in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-30-2012, 05:05 PM
  7. Require assistance with supplier spreadsheet
    By julius1973 in forum Excel General
    Replies: 4
    Last Post: 08-01-2012, 07:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1