I have a formula that takes the right characters of a block of text from a field.
If the text at the end is WR14 3PP it is bringing in R14 3PP.
If I change the formula to
It does not display them as it appears to be putting in a return in the result. I made the formula result field to Can Grow and this then shows them put puts a blank space above the result so throws all the alignment out.
Is there anything I can out in the formula so it prevent it creating carriage return or whatever it is it is doing and just show the result as expected.