Return to index: [Subject] [Thread] [Date] [Author]

RE: Excel special characters Now: Special Characters and Custom Cell Formats

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Yes,
This is the point I was trying to make in my response. You need to edit
the formula containing Bb in the long formula cell below the drop down
menu's. Highlight the character and right click on it. Choose font(?) or
format (I forget which) and you can edit the font. In the font screen at
the bottom left should be the Super and Sub script triggers. You can
also change any character to a Greek letter by using the Symbol font. It
does not convert the whole line - only the characters that you want
converted.
Hope this helps.
Dennis

-----Original Message-----
From: jpriley485(--nospam--at)peoplepc.com [mailto:jpriley485(--nospam--at)peoplepc.com] 
Sent: Monday, July 30, 2001 10:23 AM
To: seaint(--nospam--at)seaint.org
Subject: RE: Excel special characters Now: Special Characters and Custom
Cell Formats


OK, got it.

Here's another question.  Can you format SINGLE characters within a
formatted cell.  For instance, within a cell formatted thus:  "Bb =
"0.00" inches" can you cause the second 'b' to be a subscript of the
first?

-----Original Message-----
From: Dennis Wish [mailto:dennis.wish(--nospam--at)gte.net]
Sent: Friday, July 27, 2001 3:37 AM
To: seaint(--nospam--at)seaint.org
Subject: Was: Excel special characters Now: Special Characters and
Custom Cell Formats


Gosh John, you could have asked me the other night when you were slaving
away at the spreadsheet at 2 or 3AM and found me online. Another way to
do this is to create the text in the cell and then to go back to the
edit line where the complete sentence (or formula occurs) and pick each
letter you wish to convert. You can change and S into a Summation
Symbol, D into a large Delta simply by changing the font to Symbol. You
can also create sub and superscripts in this manner so that when you are
done, your complete formula is formatted the way you want. Note that you
won't see the change in the edit line as it only shows ASCII text, but
it will be reflected in the cell once you hit enter.

Here's a short trick others might find useful as well. I learned this
one from John in one of his spreadsheets on the Structuralist.Net
Software Productivity Tools forum (see link in my signature below).  You
can have a cell with a number formatted to read "Deflection = X inches"
where X is the number in the cell. To do this click on the cell with the
right mouse button and choose "Format Cell" from the menu. Click on
Formats and choose custom. In the custom box on the right type in the
following:

"Deflection = "0.00" inches"
And save the new format. When the number appears it will show up as
noted above. You can add any fancy formats you want. John makes good use
of these and I've learned a lot from looking at his spreadsheets.

The Spreadsheet forums on the Structuralist.Net is devoted to sharing
these creative ways to use the templates and tools we share. Not only
are the templates useful, but they serve a greater service when used as
references to study what another engineer has done so that we learn and
apply the new knowledge to the custom work we do. Most useful to me is
learning how others solve complicated logic. One example would be how to
distribute tributary load from the top down in a multi-story building
when walls do not align. You can learn how to do this by digging in the
Multi-Lat spreadsheet on the forum. In some cases, the logic when
created over many lines of shear and over numerous stories creates a
geometric pattern that is visible in the spreadsheet - this helps to
visualize the simplicity of a logic that starts out as seemingly
impossible.

I invite anyone who is interested to take the time and visit the
information forums on the Structuralist.Net as there is a great deal
more than spreadsheets to keep you busy.

I guess you can call this a blatant advertisement, but since there is no
profit to the forums or board I have nothing to really advertise. Hope
you don't mind.

Dennis S. Wish, PE
Administrator
admin(--nospam--at)structuralist.net
Web Site:
http://www.structuralist.net
Discussion Forum:
http://www.structuralist.net/cgi-local/UltraBoard/UltraBoard.cgi
(follow the link to the Professional Forum and then to the Software
Productivity Tools. For discussion follow the Link to the Software Users
Forum.


-----Original Message-----
From: jpriley485(--nospam--at)peoplepc.com [mailto:jpriley485(--nospam--at)peoplepc.com]
Sent: Thursday, July 26, 2001 10:47 PM
To: seaint(--nospam--at)seaint.org
Subject: RE: Excel special characters


Awesome!  I write a lot of spreadsheets . . . in fact, I hardly use
pencil and paper.  I've been skirting the issue of Greek letters for
years, due to ignorance.  You all have made my day!

Thank you.

John Riley




-----Original Message-----
From: mnowmos(--nospam--at)compuserve.com [mailto:mnowmos(--nospam--at)compuserve.com]
Sent: Thursday, July 26, 2001 10:52 PM
To: seaint(--nospam--at)seaint.org
Subject: Re: Excel special characters


Or cut and paste from "Character Map".  Most fonts seem to have hidden
special symbols that can be pasted into cells if you don't want to
change the font of the entire cell.  Especially useful if you want to
have say, "øMn" appear in one particular cell.  I hope that the special
character I just inserted doesn't get lost when this email is sent and
contradicts me. Another thing you can do is put in a text box right by
the cell text that is independent of that cell's formatting.

Mark Nowmos

"Mark E. Deardorff" wrote:

>
> In the edit bar select the english equivalent of the character you 
> want to convert to Greek. For instance if you want the uppercase 
> delta, type the letter D, select it, select Format Cells ... which 
> will bring up a font selection dialog, select the Symbol font and 
> there you are.
>
> -----Original Message-----
> From: jpriley485(--nospam--at)peoplepc.com [mailto:jpriley485(--nospam--at)peoplepc.com]
> Sent: Thursday, July 26, 2001 6:19 PM
> To: seaint(--nospam--at)seaint.org
> Subject: Excel special characters
>
> Is there a way to insert special characters, such as Greek letters, in

> MS Excel?
>
> John Riley
>
> *
> *   This email was sent to you via Structural Engineers
> *   Association of Southern California (SEAOSC) server. To
> *   subscribe (no fee) or UnSubscribe, please go to:
> *
> *   http://www.seaint.org/sealist1.asp
> *
> *   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you
> *   send to the list is public domain and may be re-posted
> *   without your permission. Make sure you visit our web
> *   site at: http://www.seaint.org


*
*   This email was sent to you via Structural Engineers
*   Association of Southern California (SEAOSC) server. To
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you
*   send to the list is public domain and may be re-posted
*   without your permission. Make sure you visit our web
*   site at: http://www.seaint.org


*
*   This email was sent to you via Structural Engineers
*   Association of Southern California (SEAOSC) server. To
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you
*   send to the list is public domain and may be re-posted
*   without your permission. Make sure you visit our web
*   site at: http://www.seaint.org


*
*   This email was sent to you via Structural Engineers
*   Association of Southern California (SEAOSC) server. To
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you
*   send to the list is public domain and may be re-posted
*   without your permission. Make sure you visit our web
*   site at: http://www.seaint.org


* 
*   This email was sent to you via Structural Engineers 
*   Association of Southern California (SEAOSC) server. To 
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you 
*   send to the list is public domain and may be re-posted 
*   without your permission. Make sure you visit our web 
*   site at: http://www.seaint.org 


* 
*   This email was sent to you via Structural Engineers 
*   Association of Southern California (SEAOSC) server. To 
*   subscribe (no fee) or UnSubscribe, please go to:
*
*   http://www.seaint.org/sealist1.asp
*
*   Questions to seaint-ad(--nospam--at)seaint.org. Remember, any email you 
*   send to the list is public domain and may be re-posted 
*   without your permission. Make sure you visit our web 
*   site at: http://www.seaint.org