Concatenate

xor · #1 12-26-2018, 03:40 AM

Then I think you should ask in the Excel Programming group.

ganesang · #2 12-26-2018, 03:51 AM

Quote:

Originally Posted by xor

Then I think you should ask in the Excel Programming group.

Do you have any other suggestions to using LEFT,RIGHT,MID,LEN,CONCATENATE,AND,OR,IF functions with "categ no" string.

I am just thinking to use this functions for this thread.....

xor · #3 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 · #4 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