Concatenate

xor · #1 12-26-2018, 08:15 AM

Don't know if this can be of any help.

To be able to use this workbook you must have access to the function TEXTJOIN which is available in Office 365. I am, not sure if it is in Excel 2016.

ganesang · #2 12-26-2018, 09:32 PM

Thanks for reply.

Sometimes the input values separated by comma having more than 50 item included.

In this case not able to split helper cells separately, because of scrolling of more columns.

Anyway i can try with excel programming.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenate function for displaying numbers in words	officeboy09	Excel	13	08-09-2021 12:59 PM
Help need for concatenate function issue	ganesang	Excel	5	11-24-2018 12:27 AM
RIGHT Function With Concatenate (?) VBA-Need Help with Macro	rsrasc	Excel Programming	4	08-22-2018 12:17 PM
Concatenate	b16	Excel	1	01-09-2017 04:51 PM
If, move and concatenate in VBA	devcon	Excel Programming	0	07-04-2011 12:44 AM