How to limit character count between commas?

[Madda1]

Hello,
I need to bulk upload to a site that limits a tag to a 20 character count including spaces.
I need a simple formula that can help put this into a cell and make sure each tag doesn't go over that limit. It will look like this.
Dog, cat, mouse, etc...
It doesn't count the comma as a character.
Thanks in advance .

[Pete_UK]

Do you mean like this:

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

and so on?

Hope this helps.

Pete

[Madda1]

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

Do you mean like this:

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

and so on?

Hope this helps.

Pete

[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

[TMS]

If the data is in cell B1:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

= 18


Regards, TMS

[Madda1]

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

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

If the data is in cell B1:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

= 18


Regards, TMS