Wednesday, April 14, 2010

Merge two cells into one cell

A new Microsoft Excel trick that I've discovered recently.

I need to merge multiple cells into one cell. Instead of wasting time, using notepad and replace here and there, I use a formula with the ampersand (&) operator to combine text from multiple cells into one cell.


how-to:
  1. At the formula bar, type =.
  2. Select cell in which you want to combine i.e U2. The formula bar will show =U2.
  3. Type &""&. If you want to make space between the two cells, you make a space or any other character between the question mark. Example, &" "& or &","& or &" + "&.
  4. Then select the next cell that contains the text that you want to combine i.e V2.
  5. The formula looks like =U2&""&V2. Press Enter to see the result.
Kerana trick yang menyenangkan ini, I've rewarded myself with satay, murtabak ayam and happily touring pasar malam with my son, Iman. But woke up late this morning. Haha.

11 comments:

Baby Gina said...

u may also use the formula below:

=CONCATENATE(1ST CELL,2ND CELL)

i.e =CONCATENATE(U2,V2)

have fun!

Wafaa said...

baby, itu aku belum try. Jap lagi try. Thank darl~~

ellyWong said...

uwaaaa.. bestnyer boleh beli terus..elly nak jugak. tapi takde gerai.. :(

Kancilbiru said...

alamak..jaraaaaaaaaang guna excel...help!

MotherOfDoubleA said...

faa..excel mmg power kalu rajin explore formula..dulu keje aku main ngn data..so terpakse mengexpertkan diri ngn excel..kalu dok..kompem hari2 blk mlm :)

natsuha said...

wei...aku sangat bengap ngan excell nih!!! camner nak cepat pandai aa??? kerja aku 90 percent pkai ecxel...sobb sobb......

Wafaa said...

Elly: gerai pasar malam ke? Sabar ye. Balik msia kang, boleh tour semua pasar malam kat klang, shah alam, pj :)

Niza: kalau tak guna excel, takyah fening2 hehehe

Wafaa said...

Watie: ya betul. cuma kadang2 kita taktau benda yg kita nak guna tu dipanggil apa :)

Jue: mari kita pegi sekolah menengah excel

Eliss said...

tiap2 bulan guna excel tapi guna excel bila nak check sapa yang tak bayar yuran kelab ajer.

Anonymous said...

aku suka excel!! dia sgt bijak.. :) wpon x tere guna formula secanggih mung, tp aku suka sbb dia senangkan keje..ngehehe..

mc.jue, jom pi belaja excell

schazzy said...

suke!!!! suke excel tips!! keep up coming!!! nanti share lg yea kalau ader formula2 magik lain..hehehe