In Excel, how do I combine 2 columns?

Question

Have first name in column 1, middle initial in column 2, want to put the middle initial next to 1st name in column 1, to match other databases I have.
Also any way to change from all caps to upper & lower case??

Answer 1

There is a 'function' called CONCATENATE. It's function is to do exactly this. After you've run Concatenate in the column you want to be merged with another one..... Then just do a Copy for the completed column (which now as concatenate in the fomula) and Paste Special and select Values - and copy in new column. You now will have the column with text only - the way you want it.

Answer 2

There are 3 techniques i can think of of... the 1st is composed of a convoluted scheme of +this+that+the_other to take the techniques and bring in in one column. the undertaking that's the pointless complexity and the issues if somebody entered city THEN highway rather of highway THEN city... the 2d is to the two careful decrease and paste, or to merge the cells. the themes indexed under are the time, and the actuality that interior the 2d, you maintain the techniques interior the "top left cellular" purely. And ultimately, retype the information into as quickly as cellular. Now, in case you prefer to apply diverse rows interior an identical column (which all yet precludes sorting in that column), drag and drop the cells from the different columns into the chosen column. sturdy luck! playstation : If somebody is responsive to a greater advantageous way, i could like to appreciate it too! :D

Answer 3

I think the other user might have answered your other question, and as far as upper and lower case here is what i found (I learned something too!):

Change the case of text
Use the UPPER, LOWER, or PROPER functions to do this task.

Worksheet example
The example may be easier to understand if you copy it to a blank worksheet.

How?

Create a blank workbook or worksheet.
Select the example in the Help topic. Do not select the row or column headers.


Selecting an example from Help

Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.

1
2
A
Name
nancy Davolio
Formula Description (Result)
=UPPER(A2) Changes text to all UPPERCASE (NANCY DAVOLIO)
=LOWER(A2) Changes text to all lowercase (nancy davolio)
=PROPER(A2) Changes text to Title Case (Nancy Davolio)

... my notes again:
You can probably do a range of cells. I used to copy text into word, so the toggle case and copy it back into excel. so thanks I learned something too.