LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help creating legend with 2 units. MillMaster Charts and Charting in Excel 0 September 1st 06 04:45 PM
characters and strings elicamacho Excel Discussion (Misc queries) 4 March 20th 06 06:17 PM
How to find number of pairs of strings from list of strings? greg_overholt Excel Worksheet Functions 5 January 27th 06 10:42 PM
last name, first name strings data_diva New Users to Excel 6 November 18th 05 10:39 PM
How can I count strings within strings Paul W Excel Worksheet Functions 4 June 14th 05 12:39 PM


All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"