How to limit character count between commas?

Do you mean like this:

=LEFT(A1,20)&","&LEFT(B1,20)&","&LEFT(C1,20)&"," ...

and so on?

Hope this helps.

Pete

Thanks for the reply Pete!
But I need all tags in one cell together separated by commas.

Originally Posted by Pete_UK

Do you mean like this:

=LEFT(A1,20)&","&LEFT(B1,20)&","&LEFT(C1,20)&"," ...

and so on?

Hope this helps.

Pete

Yes, I was assuming your individual tags were in cells A1, B1, C1 etc., and that formula (which could be in Z1 for example) will then give you what you wanted.

Hope this helps.

Pete

Thank you both so much. I've used Petes formula and it works like a charm.
Thanks again

Originally Posted by Pete_UK

Yes, I was assuming your individual tags were in cells A1, B1, C1 etc., and that formula (which could be in Z1 for example) will then give you what you wanted.

Hope this helps.

Pete

Originally Posted by TMS

If the data is in cell B1:

Formula:

=LEN(SUBSTITUTE(B1,",",""))

Formula:

=LEN(SUBSTITUTE("Dog, cat, mouse, etc…",",",""))

= 18


Regards, TMS