{"id":10533,"date":"2021-12-06T01:53:06","date_gmt":"2021-12-06T01:53:06","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=10533"},"modified":"2021-12-06T01:53:24","modified_gmt":"2021-12-06T01:53:24","slug":"solved-bold-partial-text-string-in-excel","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/bold-partial-text-string-in-excel\/20179.html","title":{"rendered":"Solved Bold Partial Text String In Excel"},"content":{"rendered":"<p>I using the CONCATENATE function to merge multiple columns with some text and carriage returns. The result is being pasted as values in the next column. The result will look like this:<\/p>\n<p>Section 1-1<\/p>\n<p>Y = -77.687<\/p>\n<p>X = (-3.454,13.500)<\/p>\n<p>I want the first line of the result to be bold. I dont want to use code as I&#8217;m not comfortable with it.<\/p>\n<p>Can anyone please help find a way in which I can use a formula\/ conditional formatting\/ replace or other non-code options to make the text string bold AFTER PASTING IT AS VALUES.<\/p>\n<p>PS: The operation needs to be carried out in approx 1000 cells and every time the first line will be &#8220;Section &#8230;&#8221; ( the &#8220;1-1&#8221; part may\/may not change)<\/p>\n<p>Thanks in advance!<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":2},"question-category":[53],"question_tags":[],"class_list":["post-10533","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/10533","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=10533"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=10533"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=10533"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=10533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}