I need to enter data in 2 columns that have a character limit of 30 each. My data has more than 30 characters. I'm looking for a formula that can trim my data and keep everything <= 30 characters in column A, then a second formula to put everything that's >= 31 into column B.
Thanks!
Bookmarks