Break this list to within the 280 characters

**ChuckyBuck** · 01-15-2020, 09:51 AM

I am working on something and have come across something I don't know if Excel will do or not. I have a list of user id's for Twitter. But I need to break this list to within the 280 character limit. Like either have it highlight them or put a space between them or something so I know where the last full line with-in the 280 limit is. Anyone know if there is a function for this or something I can do here to achieve this.

If Twitter will not do this then can someone suggest something that may?

Thanks!

**Sam Capricci** · 01-15-2020, 09:59 AM

something like a formula with left and len formulas might work.
like =IF(LEN(A2)>280,LEFT(A2,280)&"-"&MID(A2,280,999999))
untested of course but it might work (if I'm understanding what you want).
a sample workbook though would be better, just follow the instructions in the yellow banner at the top of the post.

**ChuckyBuck** · 01-15-2020, 10:18 AM

See if I did this right.

**Sam Capricci** · 01-15-2020, 10:24 AM

you posted a workbook ok, but what is needed is to put examples in it that represent the actual data (if not the actual data) AND your expected results.