Combining Cells in Excel

In Excel we can do much, such as i am gonna show how to combining cells in excel.

combine multiple cell ( minimum with 2 cells ) with &
Example :
cell a1 : Together
cell b1 : Forever
with this formula we can get TogetherForever.
How do you do it ? Heres how, just use this formula =a1 & b1

And You can use space to get Together Forever with this formula = a1 & " " & b1
Interesting isn't it?

Combine text with number too.
example :
cell a1 : 4
cell b1 : Ever
How : ="Together " & a1 & b1 ==> you'll get Together 4ever

combine text with date
="today is : " & today() ; u'll get today is : 40749
to fix this :
="today is : " & text(today();"dddd") ; u'll get today is : monday


For Others :
Format a date
="Payment is due " & TEXT(today(),"dd mmmm yyyy")
result : 25 July 2011

Format number as currency
="Amount due: " & TEXT(2500000;"Rp #.##,##00")& " Idr"
result : Amount due Rp 2.500.000,00 Idr

Format a number as a percentage:
="Your Popularity is " & TEXT(0.8,"0%")
result : Your Popularity is 80%

Format a number as a fraction:
="Hours worked: " &TEXT(5.25,"# ?/?")
result : Hours worked: 5 1/4

thx for reading this blog.