VBA Code for cutting character lenghts into another cell

[ziemann82]

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

[mike7952]

Maybe this will work

Please Login or Register  to view this content.

[ziemann82]

Mike,

I pluged that in and it works very well. thanks you so much. I was wondering is there a way to not cut the word in half when the character limit is reached. I want the whole word to either in in column a or b.

Jason

[mike7952]

Try this

Please Login or Register  to view this content.

[jindon]

Try this

Please Login or Register  to view this content.