{"id":4763,"date":"2019-11-11T08:52:50","date_gmt":"2019-11-11T08:52:50","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=4763"},"modified":"2024-03-29T14:18:22","modified_gmt":"2024-03-29T14:18:22","slug":"combine-text-with-formula","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/combine-text-with-formula\/","title":{"rendered":"Combine Text with Formula in Excel"},"content":{"rendered":"\n
In Excel, you can combine text with numbers, formulas, dates, etc., and display it inside a single cell. There are a few ways you can do it in Excel. In this tutorial, I’ll show you how.<\/p>\n\n\n\n
To combine text with numbers inside a formula<\/a>, you can use the ampersand (&) operator. This formula combines text, and cell references<\/a> (text and numbers) and displays it as a string.<\/p>\n\n\n\n You can run this formula on multiple examples, to see how it works.<\/p>\n\n\n\n=A2&\" \"&B2&\" is \"&C2&\" years old.\"<\/code><\/pre>\n\n\n\n