Excel VBA Display issue
Posted on 2014-08-05
I've had an amateurish attempt at writing a function in Excel that will take text, eg. "11.CP", remove the full stop and then leave the text preceding the full stop and after the full stop separated by char(10) which results in the two text strings being separated by a line when the cell is defined as having wrapped text.
When I use the function, it mostly displays the formula in the cell rather than the result, eg. "11" & Char(10) & "CP". If I copy and paste the format from a nearby cell, it works, but I don't think it updates if the original text were to change.
I hope someone can help though it is far from life threatening.