answersLogoWhite

0


Best Answer

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

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you combine names in column a and b to column C with no spaces?
Write your answer...
Submit
Still have questions?
magnify glass
imp
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.


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


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 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.


In music what does face stand for?

In music, "FACE" is an acronym for the names of the notes in the spaces on the staff in treble clef. A staff has five lines, and those form 4 spaces in between. From bottom to top the notes are F, A, C, E.


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.


What are the two parts of the cell identifier in excel?

The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.The column reference, which is one or more letters and the row number. So C20 is column C, row 20. DG321 is column DG, row 321.