This is because you are adding more than 15 digits.
Ex:
Ex:
| 208017690417600019 |
| 208017690417600001 |
| 208017690417600024 |
| 208017690417600014 |
| 208017690417600020 |
| 208017690417600018 |
| 208017690417600013 |
| 208017690417600016 |
| 208017690417600015 |
| 208017690417600017 |
| 208017690417600008 |
Now how to find, just follow these steps, very simple trick, see the below images.
The formula I will use: =(cell Address & cell Address)
Ex: =(A1&B1)
#MSOffice2010 #Office2010 #MSOffice2007 #Office2007 #MSOffice2013 #Office2013 #MSOffice2016 #Office2016