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
    Commented Nov 6, 2020 at 23:30

1 Answer 1



Use that in cell C1:






Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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