excel query- to make two strings into one string someone suggested formula =A1&B1?

Question

one Mr kc suggested how to apply this for all rows by copying this formula in all cells of C but i could not understand how. will kc or someone else pl guide in detail how to do it for all rows in one go.

i have diff fig in all rows e.g cell A1-10 B1-17 cell A2-20 B2-30 cell A3-82 B3-16 cell A4-12 B4-15 and i want answer in one go i.e cell C1-1017 cell C2-2030 cell C3-8216 cell C4-1215. how to bring these answers in one go

Answer 1

The previous answers are both correct, but if you need space between A1 and B1 you need to add that to your formula.

=A1&" "&B1

So if A1 was Salma and B1 was Hayek, not the cell with your formula would be Salma Hayek.

If the names need to be lastname, firstname the formula would be:

=B1&", "&A1

You can have any string between the quotes in the formula, even the & symbol.

To copy the formula down along your columns just type it in C1 and then hit enter. Re-select C1, then just double-click on the little box in the bottom right corner of C1 (the fill handle). This will copy your formula down column C as long as there is data in column B.

Answer 2

The formula '=A1&B1' will indeed concatenate the characters in cells A1 and B1 into a single string. If you then want to copy that forumla all the way down your spreeadsheet you can just select copy, highlight all the cells you want the formula to be in, then select paste.

The other easier way to do it is by clickling on the cell that contains your formula. When you do this you'll see a small black square in the bottom right-hand corner of that cell, you can then double-click that square and the forumula will automatically copy to all the cells below which have data in nearby columns.

Answer 3

Just like =A1+B1 results in a sum of those two cells, =A1&B1 will concatenate those two cells.

Example:
The contents of A1 is "sa"
The contents of B1 is "m"
Whereever you put the following formula: =A1&B1 you will get "sam".
While =B1&A1 will get you "msa".