Skip to content

How to add a cell value to a sentence in Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to add a cell value to a sentence in Excel

55,033 views December 26, 2019 2:30

Watch on YouTube

ChannelFigureAssist

Description from the creator

How to add a cell's numerical value to a sentence using the text function in Microsoft Excel

The text function in Excel is able to convert a cell's value to a string when combined with the symbol '&' which serves as a concatenation operator for Excel strings and functions. This effectively lets you combine text and formulas in Excel.

The text function has two arguments, one is the value and location of the cell you want to convert to text, and the other argument is a format_text type for specifying the type of format you want the value to be presented as.

Music by Adrian von Ziegler

About this tutorial

FigureAssist published this 2:30 video tutorial on December 26, 2019. It has been watched 55,033 times on YouTube.

Channel: FigureAssist
Category: Education
Duration: 2:30
Published: December 26, 2019
Views: 55,033
Likes: 383

Tags

Share

Further reading

How to insert cell values into a sentence in excel with ... stackoverflow.com
How can I insert cell values into a sentence like this? Scenario 1: "The person was born on" 1 "in the month of" Jan "in the year of" 1999 But if there is no month specified, the sentence should look like this:
Inserting cell values into a sentence. | MrExcel Message Board mrexcel.com
I have a question regarding inserting cell values into a sentence. Lets say I have the following cell values A1= 1,200,000 A2= 34.5267% I have the following formula in a cell ="The value of cell A1 is "&A1&" and the val…
Inserting A Cell Value Into A Sentence - Excel General ... ozgrid.com
Hi All, Hope someone can show me the light! Im trying to insert a cell value into a sentance, for example i want the date which is stored on another sheet in the work book to appear mid sentance:-

This tutorial in other languages

Web Analytics