How would you go about entering variable data into a string of Text in Excel?

Lets say I want a certain cell to display the same contents of another cell on the same or a different sheet. It's as simple as entering '=' then clicking the cell you want to mirror. What if I want data from another cell to be placed within a string of text.

For example:Let's say I want a cell to say, "There are 500 total registrants at this time," where "500" is the variable I am hoping to pull from another cell. How can this be accomplished? Asked by dwdrums 33 months ago Similar questions: entering variable data string Text Excel Computers > Software.

Similar questions: entering variable data string Text Excel.

The CONCATENATE function Try using the CONCATENATE function. Here is an example. Let's say your number "500" is in cell A1, the formula in the destination cell (let's say B1) would be: =CONCATENATE("There are ", A1, " total registrants at this time") be sure to include spaces within the text areas to surround the number found in cell A1 and use double quotes (") to define the prewritten text.

Another example might be: =CONCATENATE("Page ", A1, " of ", A2) which might display something along the lines of "Page 9 of 43". Have fun with it! Sources: personal experience BearChaser's Recommendations Teach Yourself VISUALLY Excel 2007 (Teach Yourself VISUALLY (Tech)) Amazon List Price: $24.99 Used from: $14.47 Average Customer Rating: 4.5 out of 5 (based on 9 reviews) I love the "Visually" series of books..

Simple formula You would just enter the below: ="There are "&XY&" total registrants at this time" where XY is the cell reference (probably something like A23 unless you changed the reference options). Sources: experience .

Here's how: In the cell you want the data to be in, type in the formula: =concatenate("There are ",e3," total registrants at this time. ") E3 would be the cell that you will put the number of total registrants in. Of course you can use any cell, even if it is in another sheet or workbook.

After you have typed the first part of the sentence, put in the quotation mark and added the comma, you can then go to any other cell and click on it to enter it in the formula, then Excel takes you back to the formula cell so you can finish. Text, including any spaces you need, has to be inside double quotes. Cell values cannot be in quotes or they will show up as text (e.g. : e3 rather than the value in that cell.

) Separate the expressions you want to join with commas. This will give you the results you want.It’s difficult to tell, but there is a space after the quotation mark after the ,e3, part of the formula. There is a space before the quotation mark before the ,e3,.

You can use "=concatenate" function to make quite long sentences with values from several cells in them. Sources: Experience .

" "How to Export data to Excel . Net" "how to create cards like identitycards through photoshop using by an excel data sheet" "How can I paste cells with data and comments from one excel document to another? " "How can Excel conditional formatting set a given format to any cell containing a predetermined text string?" "what is the equation in excel 2010 Windows 7 for adding time to on cell when entering into another?

" "Does anybody know of any spreadsheet software available that allows for more than 65,535 lines, which is Excel's limit? " "How do you find the median of a string of thousands of numbers in an Excel spreadsheet?" "What's the best "Turn talk into text" software?

How to add an integer value to a variable stored as string in java.

How to create cards like identitycards through photoshop using by an excel data sheet.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.