Google-sheets – Google Sheets Insert Cell Values into another Cell using formula

formulasgoogle sheetsgoogle-apps

So, I am looking to insert two cell values into one cell, one following the other.
For the following example see the Image below.Spreadsheet

I want to put a Formula in C such that the formula would result in ab
I am aware you can set one cell equal to another just by =A1, but I am looking to put both in at the same time. Something like =(=A1)(=B1),but that actually works, because this just returns the general "Formula Parse Error".

Best Answer

Solution:

Use that in cell C1:

=TEXTJOIN(,,A1,B1)

Output:

example

References:

TEXTJOIN

Related Topic