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.
This entry was posted on Friday, November 13th, 2009 at 6:24 pm and is filed under excel tips .