Define "smart". What are your rules for determining what is included in the
long text string and what isn't?

"Pukeko47" wrote:

Trying to create a very long txt string from hundreds of separate cells so I
can import into another program.
This needs to be smart as I need to do this operation often