Find solution
How to find the column name of the first column with a null value?

Excel: first name in one column, last name in another column. How do I get them in the same column?

  • I use this format b/c sorting thru long lists of names is easier. Now I want to print the names in one column with a space btwn first and last name.

  • Answer:

    In Cell C1, insert "=A1 & " " & B1", assuming first name is in A and last name is in B. Drag the fill handle of C1 to fill up the other cells. Copy the Column C and right click. Select "Paste Special", select "Values" only. Now you can delete Columns A and B if you want to.

excel challenged at Yahoo! Answers Visit the source

Was this solution helpful to you?

Other answers

click on column and drag where you want them

flossintru

If A1 had first name and B1 has last name, you can write =A1&" "&B1 as formula in C1, for example. Then, you can copy and paste to copy this formula for the entire column.

Arbitrage

Insert a "CONCATENATION" function in the 3rd column. FOr example, assume cell A3 and B3 have the first and last names. Put this formula in cell C3: =CONCATENATE(A3," ",B3) To cCopy the formula down do this: - Select the first concatenated result in column C - Hold down shift and click the LAST row in colunm C - From the top menu select Edit->Fill->Down top copy the formula. TaDa!

LonnieW

I go with arbitrage.. One more tip.. If you want to copy that entire First name and last name to other excel sheet, copy and use Paste Special and choose "Values" alone

shaggy

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.