To view this, you need to install the Flash Player 7. Please go to here and download it.

excel tips

combine / add two text cells into one

Friday, November 13th, 2009

C1=A1& " " &B1
or
C1=CONCATENATE(B2," ",B1)

so this is how you do it, adding 2 cells of text into 1.
i’ll continue to share my excel learning here, cheers

ctrl + shirt + up arrow , this highlights all datas within that column

number increments in excel
entering 1 in A1, 2 in A2, selecting *both* and then dragging down.