Joining the text in two seperate columns into one column
Joining two separate columns into one is called Concatenating. It is useful in the following instance:
You have values that need to go into the notes field - but you need to make it clear what the represent.
| A | B | C | |
| 1 | Number of Children | ||
| 2 | 3 | ||
| 3 | 2 |
So you need to create one Column (which will be imported into the Notes field) which says Number of Children: X. So you use the following formula:
| A | B | C | |
| 1 | Number of Children | Notes | |
| 2 | 3 | Number of Children: | =CONCATENATE(B2,A2) |
| 3 | 2 | Number of Children: | =CONCATENATE(B2,A2) |
NB - Remember to copy the entire column, and right click, click on paste special and choose values, which will enter the actual values of the calculation. You can then delete columns A and B, and should be left with the following:
| A | B | |
| 1 | Notes | |
| 2 | Number of children: 3 | |
| 3 | Number of children: 2 |
Previous:
Splitting Firstname and Surname
