answersLogoWhite

0

To combine names in A1 and B1, put the following formula in C1: =A1&B1. If you want a space between the names, use the formula =A1&" "&B1.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

What are the note names of the spaces on a treble clef are?

F, A, C, E. or FACE!


What are the names of the spaces on treble clef?

In ascending order, F A C E.


How do you combine two columns of email addresses into one column?

Without writing a custom macro, here are two ways you can combine two columns of any kind of data into one column. Assume your first column is in A, the second column in in B, and all data starts in row 1. In cell C1 enter one of these formulas:=A1 & " " & B1=concatenate(A1, B1)Then, copy the formula to all cells in column C that correspond with entries in columns A and B.The advantage of the first formula is that you can include a separator between the two entries: " " gives you a space; " - " gives you a dash with spaces on both sides. If you want to join the two columns without anything between the two entries, just use =A1&B1.If you mave more than two columns, use the same sequence to combine more cells.


Are cell names a column and a row labeled combined at a point?

A cell address is a combination of the column heading and row heading. So the cell that is where column C and row 3 meet, is cell C3. Cells can also be given actual names that can be used to identify them. You can have a name like Total for a cell.


What are the names of the four spaces in the bass clef from top to bottom?

The 4 spaces in the bass clef aretop to bottom would be... g e c abottom to top is a c e gYou can remember it by "All Cows Eat Grass"


1. Which of the following is false about naming functions and parameters [1 point] a. Names can have spaces. b. Names can have digits. c. Some names are reserved by python. d. Names cannot start with digits?

d


What are the names of the spaces of the bass clef?

The names of the spaces in the bass clef are (starting from the bottom) A C E G. You can remember this by using the phrase All Cows Eat Grass.


What are the names of the spaces in the Bass Clef?

Treble ClefECAFBass ClefGECAAlto ClefFDBGTenor ClefDBGE


What does''C3'' MEAN ON EXCEl 07?

C3 could refer to the cell in column C, row 3.C3 could refer to the cell in column C, row 3.C3 could refer to the cell in column C, row 3.C3 could refer to the cell in column C, row 3.C3 could refer to the cell in column C, row 3.C3 could refer to the cell in column C, row 3.C3 could refer to the cell in column C, row 3.C3 could refer to the cell in column C, row 3.C3 could refer to the cell in column C, row 3.C3 could refer to the cell in column C, row 3.C3 could refer to the cell in column C, row 3.


What formula would you enter in B16 to show the total for just the person selected on only the date entered?

To calculate the total for the selected person on the specified date, you can use the SUMIFS function. Assuming that the person's name is in cell A1, the date is in cell A2, and your data range for names is in column A and dates in column B with totals in column C, the formula in B16 would be: =SUMIFS(C:C, A:A, A1, B:B, A2) This formula sums the values in column C where the corresponding names in column A match the selected person and the dates in column B match the specified date.


What are the letter names of all the lines and spaces from lines of to five on both clefs?

In the treble clef, the lines from bottom to top are E, G, B, D, and F, while the spaces spell out F, A, C, and E. In the bass clef, the lines from bottom to top are G, B, D, F, and A, and the spaces are A, C, E, and G.


In the cell address C4 what does C signify?

The column. The columns are labelled alphabetically, e.g. "A" is column 1, "B" is column 2, "C" is column 3 and so on. The 27th column is labelled "AA", the 28th "AB" etc.