Is it possible to have Excel do an equation whereby, in Column A you have a number, Column B you have a +, -, *, / etc and in Column C you have another number. I have tried a simple =A1&B1&C1 etc but this only pastes as texts and does not pick it up as if you entered that into a cell
So I have :
What I want is
So I have :
3 | * | 5 | =A1&B1&C1 |
What I want is
3 | * | 5 | 15 |
Last edited: