#1
|
|||
|
|||
Concatenate - function help
Hi there,
I need the function which helps to concatenate the cell values which is separated by comma as follows: If cell J5 ------> A1,B1,AB1....etc which needs to be converted as follows in to cell M5 <categ no = "A1"/><categ no = "B1"/><categ no = "AB1"/> etc.... Can you please anyone help me out on this? thanks Ganesan. G |
#2
|
||||
|
||||
Please post a sample sheet with some data and expected results
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Sample attached here..........
|
#4
|
|||
|
|||
Do you mean like shown in the attached?
|
#5
|
|||
|
|||
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… |
#6
|
|||
|
|||
Not sure what you mean.
|
#7
|
|||
|
|||
This is what i need exactly.
The values in the "INPUT" column is dynamic which needs to be converted as output column..... Please let me know if not clear. |
#8
|
|||
|
|||
Can you accept to have as many helper cells (for each row) as there are categ nos?
|
#9
|
|||
|
|||
Hi XOR,
Each comma separated value in helper cell needs to be converted as each categ no. I know its very strange to apply excel formula. There is any other VBA code also would be fine. |
#10
|
|||
|
|||
Then I think you should ask in the Excel Programming group.
|
#11
|
|||
|
|||
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..... |
#12
|
|||
|
|||
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. |
#13
|
|||
|
|||
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. |
#14
|
|||
|
|||
Why not?
Why do you have to look at the helper cells at all. You just have to extend the helper cells (and the formulas) to 50 or whatever columns. By the way - always best to give full details from the start (50 items). |
#15
|
|||
|
|||
Hi XOR
I need the values in same cell instead of separated by more columns. We're not sure either which column's value is big or small to expand and add the tags in to the more columns. That's why i need the output in each respective same cell.... |
Thread Tools | |
Display Modes | |
|
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 |