Envelope Addresses

Panorama X
1

In Panorama 6 you could have the following setup for addressing an envelope:

Name
Address1
Address2
City, State, Zip

If Address2 was empty, City, State, Zip moved up under Address1 automatically and there would be no blank line. How do you get this to work in PanoramaX?

2

You could use the sandwich function, but I would be interested in a little bit more information about expanding in Panorama X

3

Another formula, would use arraystrip(.

arraystrip(Name+¶+Address1+¶+Address2+¶+City+", "+State+", "+Zip,¶)
4

No formula needed. Just use the “Collapse Blank Lines” option.

1 Like
5

Thanks Jim. That is exactly what I needed.