title: Bold text in a Concatenate formula
body: <p>I would like to be able to make one or two specific words bold in my sentence when using a concatenate formula. An example is shown below.</p>
  
  <p><a href="https://i.stack.imgur.com/tyigW.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/tyigW.jpg" alt="enter image description here"></a></p>
  
  <p>The first sentence is using the concatenate formula. The second sentence is manually typed and formatted. Is there a way to have this formatting in the concatenate formula without having to do it manually every time?</p>
  
  <p>Please note that this is just an example and I may need to use it to make a string of three consecutive words bold in a different sentence. If a general rule was provided that I can work with going forwards that would be great!</p>
  
  <p>I am somewhat proficient with formulae but have never used VBA. However I suspect the solution for this problem may only be available using VBA. Please be considerate if a VBA solution is required as it'll take some time and effort for me to start-up and understand.</p>
  
  <p>Thanks for your time and help.</p>
  
  <p>Edit:</p>
  
  <pre><code>Public Sub ExampleConcatenate()
      Dim str1 As String, str2 As String, str3 As String, str4 As String, str5 As String, str6 As String
      str1 = "First string "
      str2 = "Second string "
      str3 = "Third string"
      str4 = "Fourth string "
      str5 = "Fifth string "
      str6 = "Sixth string"
  
  
      Range("A1").Value = str1 &amp; str2 &amp; str3 &amp; str4 &amp; str5 &amp; str6 'concatenate strings
  
      'format bold starts 1 character after str1 and is as long as str2
      Range("A1").Characters(Start:=Len(str1) + 1, Length:=Len(str2)).Font.Bold = True
  End Sub
  </code></pre>
  
  <p>How would I further extend the final part to make the fourth and sixth strings bold?</p>