How to concatenate cells
There are many different ways to concatenate cells. This is really useful especially when combine with index and lookup functions which I will discuss in future posts.
In cell C3 I concatenate cell A1 and B1 which resulted to A1. The same formula as use in c2 and C3
The formula in C1 is =concatenate(A1&B1).
In cell C6 I concatenate cell A6 and B6 and added space in between which resulted to A 1. The same formula as use in c7 and C8
The formula in c6 is =concatenate(A6&” “&B6)
In cell C10 I concatenate cell A10 and B10 and added / in between which resulted to A/1. You could actually add any characters as long as it s between the “ “.
The formula in c10 is =concatenate(A10&”/“&B10)
The formula in c11 is =concatenate(A11&”,“&B11)
The formula in c12 is =concatenate(A12&”:“&B12)There are many different ways to concatenate cells. This is really useful especially when combine with index and lookup functions which I will discuss in future posts.
In cell C3 I concatenate cell A1 and B1 which resulted to A1. The same formula as use in c2 and C3
The formula in C1 is =concatenate(A1&B1).
In cell C6 I concatenate cell A6 and B6 and added space in between which resulted to A 1. The same formula as use in c7 and C8
The formula in c6 is =concatenate(A6&” “&B6)
In cell C10 I concatenate cell A10 and B10 and added / in between which resulted to A/1. You could actually add any characters as long as it s between the “ “.
The formula in c10 is =concatenate(A10&”/“&B10)
The formula in c11 is =concatenate(A11&”,“&B11)
The formula in c12 is =concatenate(A12&”:“&B12)
Brushing up on your excel ei? hehe..
ReplyDeletenice one!