Combine Text and Date in Google Doc Spreadsheet Using Formula
You can save your time in entering data in spreadsheets by intelligently using certain commands. There are lots. In this Google Doc Spreadsheet tutorial we can learn how to simplify data entry. Here we go;
- How to combine text in one cell with text in another cell.
- How to combine text in one cell with number in another cell.
- How to combine text in one cell with date in another cell.
Just like Microsoft Excel you can use the Concatenate function to combine text in different cell to one cell in Google Doc spreadsheet. Why all these required? First let us take a look at the benefit of this function. In the following similar scenarios we can use this function.
Item code with numbers and letters– In this case you can simplify the data entry. Enter number in one cell and text in another cell. Use the concatenate function – to be detailed below – to combine both. So you can quickly complete the data entry. Entering text and numbers in once cell will reduce your typing speed.
Add prefix / suffix text to date – Here also entering date and prefix / suffix in separate cells are easy. Later combine both.
This way you can complete your tasks in before time. Now to the tips.
How to Combine Text in One Cell with Number in Another Cell
Hope the screenshot itself will clear the things. The “&” symbol is to join the contents in two cells. The quotes are used to put a space between the contents. You cam omit it.
Same way you can combine text in one cell with text in another cell. But this very rarely required and no specific benefit by doing so.
How to Combine Text in One Cell with Date in Another Cell
Here, in the example, we combine text+text+date. We are using “&” to join contents same as above. But for the date, we have to apply the text command. See the screenshot for detail.
You can copy ‘the formula’ downwards to apply this to multiple cells. Any doubt? Feel free to ask in commands.
About Article Author
We have a separate section on Info Inspired completely dedicated to Google Doc Spreadsheet Tutorials. In this post we can
Learn how to use important logical functions IF, AND, OR in Google Doc Spreadsheet. Logical functions are very easy to
Earlier we have posted a complete tutorial about creating line chart in Google Doc Spreadsheet. Now in this post we
This is an another awesome Google Doc Spreadsheet tutorial from Info Inspired team. Refer our growing dedicated Google Doc Spreadsheet
Hope you are a regular reader of our Google Doc Spreadsheet tutorials. We already have some rich content there to
It is not necessary to depend PowerPoint to make ‘powerful’ presentations. You can use Google Drive Presentation easily to make