• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 234
  • Last Modified:

Combine values of 3 columns into one

I have 3 Columns : K, L, M.
Sample values in a row : (K) Dog (L) Grooming (M) Shampoo

I want to string all the values together and put them in another column (like "X" for example) so they look like this :
Dog,Grooming,Shampoo

word, comma (no space) word, comma . .

Can this be done? thanks
0
MikeMCSD
Asked:
MikeMCSD
  • 3
1 Solution
 
Haris DjulicCommented:
use function =CONCATENATE

=CONCATENATE(k1;",";l1;",";m1)

0
 
Haris DjulicCommented:
with trimming spaces and making sure that they are text..

=CONCATENATE(trim(text(k1;0));",";trim(text(l1;0));",";trim(text(m1;0)))
0
 
MikeMCSDAuthor Commented:
thanks . .
I put this formula in X2, but it doesn't display the values, it displays only the forumula.
How do I get this applied to all 2000 rows?
0
 
Haris DjulicCommented:
it seams that you column X is formated as text. in order to apply the formula , format the column X as General , and then paste the formula
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now