I am making a worksheet in which the data is registrerd in one sheet, and
then used to generate text to paste in to an administrative system. We also
use the data to generate letters to customers.

The data often consist of text with varable length. And when converted to
text, I often get big "gaps" between the words, and even extra lines. Seems
like the fact that the text consists of data from up to 5-10 cells, makes the
textprogram add thees extra space and lines.

How can i incorporate the data in til the sentences, so that it looks
professional and tidy?

Thanks!
--
Hans

Take a look at the TRIM function, which removes extra spaces.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Hans the norwegian" wrote:

I am making a worksheet in which the data is registrerd in one sheet, and
then used to generate text to paste in to an administrative system. We also
use the data to generate letters to customers.

The data often consist of text with varable length. And when converted to
text, I often get big "gaps" between the words, and even extra lines. Seems
like the fact that the text consists of data from up to 5-10 cells, makes the
textprogram add thees extra space and lines.

How can i incorporate the data in til the sentences, so that it looks
professional and tidy?

Thanks!
--
Hans