Posted to microsoft.public.excel.misc

Pete_UK

external usenet poster

Posts: 8,856

Creating strings for legend

Or slightly simpler:

=TEXT(A2,"0")&" deg"

Hope this helps.

Pete

On Apr 27, 3:58*am, wrote:
Got it now.. the correct expression is:

* *=CONCATENATE(TEXT(A2,"0"), " deg")

* * * * * * * or

* *=CONCATENATE(TEXT(A2,"0"), " °")

where the ASCII code for the ° symbol is: *Alt+0176

* * -G

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 08:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us