The result of the CONCATENATE function is always a text string, even when all the source values are numbers.Ĭoncatenate Cells with Space, Comma, and Other Characters.If the CONCATENATE function's arguments are invalid, the formula returns a #VALUE! Error.There should be at least one “text” argument in the CONCATENATE function for it to work.You should follow some rules to ensure that the CONCATENATE function always delivers the correct result. =CONCATENATE("Today is ",TEXT(TODAY(), "dd-mmm-yy")) You can also concatenate a text string and a formula calculated value.įor example, you can use the following formula to return the current date:
=CONCATENATE(A2, " ", B2, " SIMPLILEARN")Ĭoncatenating a Text String and Formula Calculated Value You can use the function to join a cell value and a string as well. The Excel CONCATENATE function is not only limited to joining cell value. To separate the values with space, use “ “.Ĭoncatenating a Text String and a Cell Value The values will be combined without any delimiters. The simple formula to CONCATENATE the values of two cells A2 and B2 are as follows: This is the more practical complement to our “ten commandments of inputting data.Concatenating the Values of Several Cells (We discuss this with more details in Chapter 3) So here is a list of functions that you should learn to use in order to store and analyze your data using a spreadsheet editor. What we just say is that learning them is not necessary to quantify properly, and that they are more difficult to learn, in our experience, than the proper use of a spreadsheet editor. Nothing wrong with those, and please do use them if you know how to (you’ll still have to export. So you won’t find advice on this blog about database managers or the TEI.
(Sharing data with the general public is a different matter) For a PhD dissertation, say, or for any other project that is personal or involves just a few collagues. Excel or Calc, the Open/Libreoffice equivalent) if you want to properly store (input) and analyze (categorize and create visualizations and calculation based on) historical data for a research project. Years of experience have convinced us that you don’t need a more sophisticated tool than a spreadsheet editor (i.e.
0 kommentar(er)
