Yes. I have a code 13 character. And when I split the column on #(cr), that works. Text.Clean also works. But that leaves me without a space between two words in my column of labels wherever they were wrapped.
Luckily, I have only one #(cr) per item in the column. So as a workaround, I've split the column into two columns, replaced any nulls in the second column with a null string, and then concatenated the two columns. It works; but it's a kludge.
Aw, well. It's handled for now. I'll have to revisit it in the future.
Yes. I have a code 13 character. And when I split the column on #(cr), that works. Text.Clean also works. But that leaves me without a space between two words in my column of labels wherever they were wrapped.
Luckily, I have only one #(cr) per item in the column. So as a workaround, I've split the column into two columns, replaced any nulls in the second column with a null string, and then concatenated the two columns. It works; but it's a kludge.
Aw, well. It's handled for now. I'll have to revisit it in the future.
Thanks for your question. It made sense.
@RonRosenfeld-3452