Should be simple

[kolarbr]

I think this should be an easy fix but am not sure how to accomplish it.

I have 2 columns populated with data, "a" and "b". I want to take the contents of column "b" and append it to the end of the contents in column "a".

Example
"a" "b"
abc 123

Should become

abc123 123

The catch is I want to be able to do this without have to add a new column into my spreadsheet. Can't you do something like abc + "B1" or abc & "B1"?

THANKS!!!

 

[mikerickson]

If "abc" is in A1 and "XYZ" is in B1, the formula =A1 & B1 returns "abcXYZ" and =A1 & B1 & B1 returns "abcXYZXYZ"