2007-01-20 10:05:10 · 4 answers · asked by Rodney 2 in Computers & Internet ➔ Software
If the name is in cell A1 and the surname is in cell B1 then put this in the cell you want it in =A1&B1
2007-01-20 10:14:14 · answer #1 · answered by Brian 5 · 0⤊ 0⤋
It's best to test this first in a new spreadsheet. I did it with just one name.
Let's assume the name and surname of the person you want to combine is in cell A1 (John) and B1 (Smith). If you go to a new column and use the formula =A1&" "&B1 you'll get John Smith.
Next, to get rid of the formula and just have John Smith as the contents of your cell, copy the cell where the formula is to the clipboard and select Paste Special. Select Values from the resulting menu.
2007-01-20 18:27:34 · answer #2 · answered by Novice 2 · 0⤊ 0⤋
@rse - i knew the answer to that one but was too damn late.
The answer is both of the above A1&B1 is a quick way to join 2 cells, use Cocatenate of you want to join more than 2 as you will get a little formula wizardy thingy that pops up on screen to help you select the cells quickly.
To split it back out again use the 'text to columns' tool - but you knew that already didn't you.
2007-01-20 18:22:40 · answer #3 · answered by millerman022002 3 · 0⤊ 0⤋
Use the concatenation function to add two strings of letters together including with a " " between them to read nicely.
Example is =CONCATENATE("first", " ","last") to get "first last"
2007-01-20 18:15:22 · answer #4 · answered by Rich Z 7 · 0⤊ 0⤋