[Webinar] Streamline your web hosting managementRegister Today

x
  • 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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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