excel 2003 visual basic intermediate course - text function

AI Training: For Busy Decision Makers & Professionals Book now

Forum 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

resolvedResolved · 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.


 

Excel tip:

Random Numbers

Type =RAND()*200 to generate a number between 1 and 200.
Use the fill handle to drag down and populate as many cells as you'd like with random numbers.

View all Excel hints and tips


Server loaded in 0.12 secs.