I would like to run a macro on selected cells that perform the following action:
The macro is to add a manual line break before each and every substring that starts with 'X0****'
The macro is to run these actions in the cell itself not copying the cell contents to the right and perform the action there.
The cell height has to be adjusted depending on the number of line breaks that get inserted.
Help is very much appreciated. I have attached a sample file for your convenience.