answersLogoWhite

0


Best Answer

You can use the Concatenate function or the & operator. Both of the following will result in the same thing:

=CONCATENATE("abc","def")

="abc" & "def"

User Avatar

Wiki User

10y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you join the text in two cells together in a spreadsheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Are cells the text areas in a spreadsheet?

A cell is an open box on a table, and as such, yes cells are text areas on a spreadsheet.


Are the text areas in a spreadsheet?

cells


What are words or text in a spreadsheet called?

Words or text in a spreadsheet are typically referred to as "labels," "text data," or simply "text." These serve as descriptions or identifiers for the data in the spreadsheet cells.


Can you format a spreadsheet?

A large amount of formatting can be done in a spreadsheet, such as changing number formats or changing colours of cells or text in cells. There are many built-in formats known as Autoformats that can be used.A large amount of formatting can be done in a spreadsheet, such as changing number formats or changing colours of cells or text in cells. There are many built-in formats known as Autoformats that can be used.A large amount of formatting can be done in a spreadsheet, such as changing number formats or changing colours of cells or text in cells. There are many built-in formats known as Autoformats that can be used.A large amount of formatting can be done in a spreadsheet, such as changing number formats or changing colours of cells or text in cells. There are many built-in formats known as Autoformats that can be used.A large amount of formatting can be done in a spreadsheet, such as changing number formats or changing colours of cells or text in cells. There are many built-in formats known as Autoformats that can be used.A large amount of formatting can be done in a spreadsheet, such as changing number formats or changing colours of cells or text in cells. There are many built-in formats known as Autoformats that can be used.A large amount of formatting can be done in a spreadsheet, such as changing number formats or changing colours of cells or text in cells. There are many built-in formats known as Autoformats that can be used.A large amount of formatting can be done in a spreadsheet, such as changing number formats or changing colours of cells or text in cells. There are many built-in formats known as Autoformats that can be used.A large amount of formatting can be done in a spreadsheet, such as changing number formats or changing colours of cells or text in cells. There are many built-in formats known as Autoformats that can be used.A large amount of formatting can be done in a spreadsheet, such as changing number formats or changing colours of cells or text in cells. There are many built-in formats known as Autoformats that can be used.A large amount of formatting can be done in a spreadsheet, such as changing number formats or changing colours of cells or text in cells. There are many built-in formats known as Autoformats that can be used.


How do you make a spreadsheet with text and numeric data?

Every spreadsheet is different. So what you do will depend on what the spreadsheet is required to do. You will type your text and numbers into cells and then add in other elements, such as formulas or charts. You can format your text and numeric data as appropriate to the spreadsheet you are creating.


What does spreadsheet application do?

A spreadsheet is a computer application that simulates a paper, accounting worksheet. It displays multiple cells that together make up a grid consisting of rows and columns, each cell containing alphanumeric text, numeric values or formulas.


What do spreadsheet applications do?

A spreadsheet is a computer application that simulates a paper, accounting worksheet. It displays multiple cells that together make up a grid consisting of rows and columns, each cell containing alphanumeric text, numeric values or formulas.


How do you insert a repetitive text using spreadsheet?

Highlight all the cells where the text is to go, then type the text into the 1st cell, and hold down the control key and press enter. All the cells will have the same text immediately.


What are the text areas in a spreadsheet?

You can add text to all areas of a spreadsheet.


Is Excel a spreadsheet processor and a text editor?

It is a spreadsheet, but not a text editor.


Do comparison operators join strings of text in different cells?

no


What is the name of operators which join strings of text in different cells?

concatenation (the symbol is &)