Problem : You have data in two cells and you want to combine them into a single cell.
To do that we’ll use a formula with the & operator, which connects—or combines—the text or numbers in two or more cells to produce one text or number value.
For example, you have a list of first names in column A and last names in column B. To combine them into one cell, enter the following formula in C1:
=A1&B1
If A1 contains ADHI and B1 contains NUGROHO, C1 will display ADHI NUGROHO . To add a space between the first and last name, use the following formula—adding the quote marks and a second &:
=A1&” “&B1
or :
=CONCATENATE(A2," ",B2) Combines the text, separated by a space.
To do that we’ll use a formula with the & operator, which connects—or combines—the text or numbers in two or more cells to produce one text or number value.
For example, you have a list of first names in column A and last names in column B. To combine them into one cell, enter the following formula in C1:
=A1&B1
If A1 contains ADHI and B1 contains NUGROHO, C1 will display ADHI NUGROHO . To add a space between the first and last name, use the following formula—adding the quote marks and a second &:
=A1&” “&B1
or :
=CONCATENATE(A2," ",B2) Combines the text, separated by a space.
Tidak ada komentar:
Posting Komentar