Combine text in excel

[minhtien1900]

Dear All,

I have an excel file as attachment, I wish to combine all the value which have the same date in to Result column,
Kindly help me to solve it , thank so much.

<img src="https://uphinhnhanh.com/images/2018/02/02/Capturebd541.png" alt="Capturebd541.png" border="0" />

Thanks and best regards,
Tien

[sandy666]

this is not an excel file but picture

Pictures are useless. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
Include in the attachment any code you're currently using (whether it works or not) and an After of what you wish the output to be.

In attached Excel file try not use:

• merged cells
• unnecessary formatting like: colours, borders, aligning another than default, etc...
• unnecessary zoom

You have words to logically describe the problem

To attach an Excel file to your post,

• desensitize data
• remeber that your example should reflect structure and type of data
• click Go Advanced,
• scroll down until you see Manage Attachments,
• click that and select Browse,
• select your file and click Open,
• click Upload and you will see your attachment below Upload Files from a website
• click Close this window,
• click Submit reply

After that you should see attachment in your post

[minhtien1900]

@sandy

Sorry for my mistake, i forgot to upload excel file. excel file already be attached, kindly help me to resolve the issue,
thanks

[Glenn Kennedy]

This will allow for any number of terms to be concatenated. If you do not want VBA, what is the MAXIMUM number of terms that will have to be concatenated?

Please Login or Register  to view this content.

How to install your new code
Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)


Then use this formula:

=concatif($A$2:$A$7,A2,$B$2:$B$7,", ")

copied down.