Yahoo Groups archive

QTR-Quadtone RIP

Index last updated: 2026-04-28 23:12 UTC

Message

RE: [QuadtoneRIP] How do I import Excel files into QTR?

2007-02-12 by Tom Moore

Ben

To create a string consisting of 2 numbers separated by a semicolon with no
spaces use the Excel Concatenate and Text functions, as in

	=CONCATENATE(TEXT(D43,"0.0##"),";",TEXT(E43,"0.0##"))

		Where d43 and E43 contain the values of the coordinate pair
you are want to output. For an array of pairs you would have to create a row
with a sequence of these string formulas and then output this row of text
strings rather than the original numbers.

Hope this helps.

Tom Moore

Attachments

Move to quarantaine

This moves the raw source file on disk only. The archive index is not changed automatically, so you still need to run a manual refresh afterward.