+ Reply to Thread
Results 1 to 3 of 3

How to put a text before and after sentences

  1. #1
    Registered User
    Join Date
    08-28-2019
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    9

    How to put a text before and after sentences

    Hi,

    I need to add an html code (<b></b> before and after to all section text and article include the number and dot behind it like this <b>Section. 1.</b>.
    Detail is in attachment.
    Is there any way to do it by search and replace? Or any solution in a quick way.
    Thank you very much in advance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-04-2018
    Location
    Europe
    MS-Off Ver
    Office365
    Posts
    78

    Re: How to put a text before and after sentences

    Hi,

    Try in B1

    =IF(OR(LEFT(A1,3)={"Art","Sec"}),"<b>"&A1&"</b>","") then drag down.

    or

    =IF(OR(LEFT(A1,7)={"Article","Section"}),"<b>"&A1&"</b>","") then drag down.
    Last edited by Tommy90; 05-04-2020 at 03:30 AM.

  3. #3
    Registered User
    Join Date
    08-28-2019
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    9

    Re: How to put a text before and after sentences

    It works. Thank you very much for your help.

+ 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. Convert shorthand time text strings into full sentences
    By amit2385 in forum Excel General
    Replies: 3
    Last Post: 10-16-2018, 05:57 PM
  2. Problems reading text files containing SQL sentences created by SSMS
    By bagullo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-09-2016, 07:49 AM
  3. Need Help Understanding how to look up sentences.
    By afmccombs in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-13-2015, 12:12 AM
  4. Find a requested word within sentences and output those sentences elsewhere
    By swfred2000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-19-2014, 02:24 PM
  5. Text functions to add X character in between sentences
    By dvpe in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-07-2014, 12:54 PM
  6. [SOLVED] Fractions in sentences
    By blacky1 in forum Excel General
    Replies: 2
    Last Post: 04-26-2012, 02:52 AM
  7. gaps between first and second sentences
    By darek in forum Word Formatting & General
    Replies: 4
    Last Post: 04-29-2011, 08:55 PM

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