How to Check Tweet Length in Google Sheets

As a social media manager, I use tools to help me bulk upload tweets.

I currently use Status Brew that allows me to upload as many as 400 tweets at once.

I’d type out all the tweets on a spreadsheet, add hashtags and spell check. Once that was done, I’d pop over to Status Brew and upload the csv file. Several “tweets” would be denied because they were over that magical 140 character limit… boo…

So, I scoured the internet and finally found a great formula to plug in that will give you the length of the tweets.

I’m sharing this with you so you can skip the frustration!

Check out the video…

 

Quick recap…

In cell B1 enter =LEN(A1)

Drag the formula down to check the spreadsheet

I hope you find this useful. Let me know if you have any questions and I’ll help you out!

I was a nurse until chronic illness took me out of the game. Now, I’m a freelance writer and social media manager. I have 4 boys and supervise many, many lightsaber fights in my free time…