98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Text function and combining columns
excel 2003 visual basic intermediate course - Text function and combining columns
Resolved · Low Priority · Version Standard
Anna has attended:
Excel Advanced course
Text function and combining columns
how do i combine two columns into one?
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.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Random NumbersType =RAND()*200 to generate a number between 1 and 200. |