I'm trying to seperate a cell with an average of 90 characters into 3 seperate cells with 30 characters each. I've used the LEFT formula for the first cell and the MID formula for the other two. The problem I'm running into is that I can't have a word cut off. Is it possible for me manipulate the formulas in such a way that it will know to return 30 characters unless there is a word being cut off? (In this case it should return less than 30; or go back to the previous space) PLEASE HELP!