answersLogoWhite

0

If one cell contains a first name and another contains a last name, you can bring the two together into one cell in two ways. You can use the & operator or the CONCATENATE function. So if the first name was in A2 and the last name in B2, then in C2 you could have either of these formulas, which also put a space between the two elements:

=A2 & " " & B2

=CONCATENATE(A2, " ", B2)

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

Is excel case sensitive with respect to names of cells?

No.No.No.No.No.No.No.No.No.No.No.


What can help add clarity to your formulas by allowing you to assign names to cells in excel?

name manager


What are the default names given to the sheets in a workbook on Excel?

Excel workbooks start with three sheets when first opened. The default sheet names are: Sheet1, Sheet2, and Sheet2.


Does Microsoft Excel consider names to be relative references?

Named cells are normally used to reference specific cells, so they would be absolute references.


What is the first row of the excel database that contains field names called?

heading row


The autocorrect feature in excel capitalizes the first letter in names of days?

To disable the autocapitalization feature in Excel for names of days, you can go to the File menu, select Options, choose Proofing, and click on AutoCorrect Options. From there, you can uncheck the option that says "Capitalize the first letter of sentences" which should prevent Excel from automatically capitalizing the first letter in names of days.


You want to combine 2 names to make 1 nameideas the names are Runeil Natasha?

You could combine them as "RuNa," taking the first two letters from Runeil and the first two letters from Natasha to create a unique name.


Take multiple names in different rows and make one row?

To combine multiple names from different rows into a single row, you can use a spreadsheet program like Excel or Google Sheets. You can utilize the CONCATENATE function or the "&" operator to merge the names. For example, if names are in cells A1, A2, and A3, you can use the formula =A1 & ", " & A2 & ", " & A3 to create a single row with all names separated by commas. Alternatively, you could copy the names into a text editor and manually join them with commas or other separators.


Is there a data base that will allow you to put names at the top - not letters like Excel?

You could use a database like Access or Oracle. You could also use the first blank row in Excel for your headings and Excel can work on them like a database.


What do you call the sheets in excel?

Normally when you open Excel there are 3 sheets open. They are Sheet1, Sheet2 and Sheet3. Sometimes you will want to give more meaningful names to those sheets. By right clicking on the sheet tab and clicking the Rename option or by double clicking, you can rename a sheet. So you could have many sheets with names on them that are meaningful to what you are doing, which is what we mean by naming sheets.


Can cell names contain spaces in Excel?

No.


What are the names of the cells that make up your body?

John's cells? Animal cells? You can name them by function, location, species, or first describer's name.