{"id":1798,"date":"2012-08-23T11:36:03","date_gmt":"2012-08-23T11:36:03","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/exceltraining\/?p=646"},"modified":"2023-12-30T23:12:17","modified_gmt":"2023-12-30T23:12:17","slug":"showing-text-from-another-cell","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/showing-text-from-another-cell\/","title":{"rendered":"Showing text from another cell (concatenation)"},"content":{"rendered":"<p>Today I wanted to be able to show the text which was stored in another cell, within a &#8216;string&#8217; of text.<\/p>\n<p>I wanted to have a name &#8216;John&#8217; as plain text in cell C3. In cell A1, I wanted to be able to display &#8216;Hello &lt;whatever is in cell C3&gt;&#8217;.<\/p>\n<p>My colleague Doug here at Best STL taught me how to do it: Concatenation.<\/p>\n<p>This is the formula:<\/p>\n<p>=&#8221;Hello &#8220;&amp;C3<\/p>\n<p>Simple as that.<\/p>\n<figure id=\"attachment_648\" aria-describedby=\"caption-attachment-648\" style=\"width: 307px\" class=\"wp-caption alignnone\"><a href=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/08\/concat.gif\"><img decoding=\"async\" class=\"size-full wp-image-648\" title=\"Concatenation example in Excel\" src=\"https:\/\/www.stl-training.co.uk\/b\/exceltraining\/files\/2012\/08\/concat.gif\" alt=\"Concatenation example in Excel\" width=\"307\" height=\"221\" \/><\/a><figcaption id=\"caption-attachment-648\" class=\"wp-caption-text\">Concatenation example in Excel<\/figcaption><\/figure>\n<p>Now I can update the name in cell C3 and all cells that reference will be changed instantly.<\/p>\n<p>Thanks Doug!<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Today I wanted to be able to show the text which was stored in another cell, within a &#8216;string&#8217; of text. I wanted to have a name &#8216;John&#8217; as plain text in cell C3. In cell A1, I wanted to be able to display &#8216;Hello &lt;whatever is in cell C3&gt;&#8217;. My colleague Doug here at [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[107,454,471,491],"class_list":["post-1798","post","type-post","status-publish","format-standard","hentry","category-excel-training","tag-concatenation","tag-reference-cell-text","tag-rt","tag-show-text-from-other-cell"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=1798"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1798\/revisions"}],"predecessor-version":[{"id":6729,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/1798\/revisions\/6729"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=1798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=1798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=1798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}