Hello All,
have found many helpful solutions in this forum and now its time for me to also post a question!
I have an excel with many columns and many rows. In each row columns can have a variable text length.
When the length is more that 800 I need to add delimiter(s) and basically split it in chunks of 800 chars or slightly less. I am not allowed to cut any words so the delimiter has to be added where a there is a space. I have tried a few ways to solve this but cannot code the part where when the 800 position is within a word to go back and select the space prior to ensure the delimiter is entered at max pos 800 or slightly earlier in case there is word at that position.
Any help will be greatly appreciated! Thanks in advance!
have found many helpful solutions in this forum and now its time for me to also post a question!
I have an excel with many columns and many rows. In each row columns can have a variable text length.
When the length is more that 800 I need to add delimiter(s) and basically split it in chunks of 800 chars or slightly less. I am not allowed to cut any words so the delimiter has to be added where a there is a space. I have tried a few ways to solve this but cannot code the part where when the 800 position is within a word to go back and select the space prior to ensure the delimiter is entered at max pos 800 or slightly earlier in case there is word at that position.
Any help will be greatly appreciated! Thanks in advance!