View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] gabbey.maps@bkwds.dynanet.com is offline
external usenet poster
 
Posts: 12
Default Creating strings for legend


Several spreadsheet have a row of angles from 0 to 360° step 5° and it
would be great to create a row above that which has a character string
for use in the legend box. This new row would have the angle (0-360)
with " deg" concatenated. What is the expression for this row?

Example:

0 deg 5 deg 10 deg 15 deg

0, 5, 10, 15,

The expression must also work for angles from -180 to +180

-G