Wed 10 Oct 2007, 16:07Delegate Carri said...
Carri has attended:
Excel Advanced course
PowerPoint Introduction course
Text Functions
How to combine two columns of text together in one cell?
Thu 11 Oct 2007, 10:35Trainer Pete said...
RE: Text Functions
Hello Carri, 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.
