I am trying to write a macro for the following: I have one column of data and i want to put a character limit of 45 in each cell in the column. If there are characters that exceed 45 characters i want to cut the excess characters into the right cell in the next column. Some times the cell would have less or more then the characters in it. I have attached a example. I am new to writting Macros and detailed explaination would be great. Thanks in advanced. When the characters are cut, i want to not cut the word in half, i want the whole word.Book1.xlsx