answersLogoWhite

0


Best Answer

numbers: =A1+A2

text: =A1&A2 or =A1&" "&A2

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the formula for joining two data in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are two ways to accept data in Excel?

Press the Enter key. Click on the tick beside the formula bar when you are typing it in.


What are the lots types of data in MS Excel?

MS Excel uses two types of data: text and numbers.


Is it possible to connect two Excel workbooks connect data from one to another?

Is it possible to connect two excel workbooks connect data from one to another?


Which two commands in excel are data visualizations?

Color scales and data bars


What is the difference between projecting and joining?

projecting: manipulating data to eliminate columns in a table. Joining: manipulating data to combine two or more tables.


What is the Excel formula to show exponents?

There are two ways to express exponents in Excel.=6^3=POWER(6,3)


Can you switch data from Works to Excel?

Yes, you can import MS Works data into MS Excel. thanks you can use two options first is paste and other one is paste special which is linked with excel with word.


What is a two-input data table in excel?

It is a table that is built on a formula that has two values to be entered in. One would be coming from a row of figures across the top of the table and one from a column of figures down the side of the table.


What two tabs are featured in excell and not in Word?

Formulas and data are two tabs that you will find in Excel and not in Word.


What is the name of a function in Excel that adds data that matched two or more criteria?

The SUMIFS function.


What is the meaning of the Formula Bar?

A formula bar is used to work in Microsoft Office, spreadsheet or others to format cells, combine text from two cells into one, format numbers to add, subtract etc. It's a bar where you can choose different formats for data.


What term is used to describe joining two or more functions into super function in Excel?

If one function is inside another, then the functions are nested.