Put in C1: =A1&" "&B1
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.
LOBI
You can combine the names "Michael" and "Juliet" to create the name "Micheliet" or "Julichael."
Ideally have the names in the first column of your data. Then select the column that has the names in it and the other columns. The active cell should be in the first column. Then go up to "Data" on the toolbar or the Sort and Filter options. You can select to sort alphabetically. If the Names are not in the first column you can use the Advanced sort option and choose it as the column you want to sort on when all of the columns of data are selected.
Shnaula
Sakneshia
you cant
By clicking the NAME column heading.
Name column heading.
By their column and row. A4 is the cell at column A, row 4 for example. Cells that have been given names will have their names show.
Antricia Pannicia
Todi