1

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".

  • The cell values are text, so you’re not trying to perform mathematical addition. There are a bunch of formulas for joining text, but you could also try “=A1&B1” – Tedinoz Nov 6 at 23:30
1

Solution:

Use that in cell C1:

=TEXTJOIN(,,A1,B1)

Output:

example

References:

TEXTJOIN

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.