I am trying to tidy up the text within a range
The above works.
If I put MsgBox .value inside the block it comes up with type miss match error.
What i am trying to do is i need to get rid of any "," at the end of all strings. I need t get the string length and reduce the font size by 1pt (now its if the lenght of the string is over 43. Also I want to split up the text to different cells if the string lenght is over 43 and there is a coma in the string and the adjacent cell to the right is empty. I dont know if i am asking for too much.