"Seandainya di depan mataku ini ada tembok berwarna putih, lalu Muhammad mengatakan bahwa tembok itu berwarna hitam, maka aku akan bohongkan mataku, dan akan kukatakan bahwa tembok itu berwarna hitam!". (perkataan Abu Bakar radhiallahu anhu, dinukil dari ceramah sejarah Nabi, oleh Khalid Basalamah)

15 Oktober 2009

Excel Trick : Combining two cells

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.

Tidak ada komentar: