Wed 10 Oct 2007, 16:08Delegate Anna said...
Anna has attended:
Excel Advanced course
Text function and combining columns
how do i combine two columns into one?
Thu 11 Oct 2007, 10:02Trainer Pete said...
RE: text function
Hi Anna, Thank you for your question, to undertake this action you will need to use the Concatentate function. Assuming that you wished to combine data from cell B4 and C4 you can use the following function in a new cell (ie A4) =CONCATENATE(B4," ",C4), note the " " space between the two cell references, this is necessary to separate the two text items.
