@DSmith2300 this can probably be written better.  But I've always thought that a script that works ugly today is better than a pretty script next week.   @Pat Stanford might be able to find the holes in my logic here.  But this works.   From the attached file import into your file [or better yet, a copy of your file] the worksheet "Crazy Text Worksheet" and the script palette WS Text.   Recalculate the worksheet.  If it gives you a warning about executing scripts, s
    • Like
    2