Concatenate.JPG
Please help how can i formulate this.
Concatenate.JPG
Please help how can i formulate this.
If first output cell is E2
Formula:Please Login or Register to view this content.
Try this:
Formula:Please Login or Register to view this content.
The formula assumes your headings are in row 1, with the data in columns A-D from row 2 downwards, with the 'Output' column in column E. Change the cell references to match where your data actually is.
Edit: this is different from the previous post by adding a space after each entry (to avoid getting something like 'Desktop1Desktop1') and using TRIM to get rid of extra spaces.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Thanks for the rep. If that means that you're happy that your question has been answered, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Thanks.
thank you all for the answer.
i have another request, how about i change my output based on the category or combination of devices. see below screenshot for output2.
Concatenate.JPG
Please try, it could be a lot shorter if you have Excel365 with Textjoin function.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks