QTR-Quadtone RIP

Terrific. Thanks Tom! I never would have found that for myself. I'll try it in a couple of days 
when this stomach bug I have lets me think clearly again...

Best,

Ben

--- In QuadtoneRIP@yahoogroups.com, "Tom Moore" <r.t.moore@...> wrote:

>
> 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
>