Concatenate

xor · #1 12-26-2018, 01:14 AM

Do you mean like shown in the attached?

ganesang · #2 12-26-2018, 02:30 AM

Thanks for the reply...

No.

Values in the cell which is in same cell and comma separated is dynamic, the values are changing one or more items with comma separated.

for example sometimes,

Cell A1 contains like -----> S1,J1,K2,SD1....etc (there is no count)

required output at any cell like ------><categ no = "S1"/><categ no = "J1"/><categ no = "K2"/><categ no = "SD1"/> etc…

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