Reason 3 – Passing a Range as an Argument in CONCATENATE Function TheCONCATENATEfunction doesn’t accept a range of cells as arguments. If you try to concatenate a range directly, it won’t work as expected. For instance, typing the following formula in cellD5won’t yield the desired resu...
When you enter numbers containing 11 or more digits, MS Excel converts them to exponential (in scientific format). Converting back is possible in a number of ways. The problem will look like this. Solution: Steps: Select cellD5and type the following formula. =CONCATENATE(C5) PressEnter. Th...