how to use Sigma

Hi all,

In a cell I want to use the capital sigma like in

="Σ = "&BL21+BM21

If I got it right there is no possibility to make a Σ in Excel,

but in Word I used 03A3 Alt+x and from there I put it with ctrl c ctrl V in my formula.

I there a smarter or faster or easier way to get Σ in a cell in Excel when anf where I need it?

Thanks in advance for your advice.

This thread is locked. You can vote as helpful, but you cannot reply or subscribe to this thread.

Answer

You can do it a couple of ways, depending which version of Office you are using.

In 2010, on the Insert tab, Symbols group, you can use Symbol to give you the Symbol Chooser dialogue box. Sigma is in the Greek/Coptic section.

If you are comfortable with VBA I found this snippet which worked for me:

Sub InsertSigma()

' Inserts the SIGMA symbol in current cell

ActiveCell.Value = "S"

ActiveCell.Font.Name = "symbol"

End Sub

If it works for you, you can add it as a button to the Quick Access Toolbar.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Answer

If you format the whole cell as Symbol, then you can use

="S = "&BL21+BM21

The symbol font displays an upper case SIGMA for an upper case S.

If you wanted to mix fonts, then you can't do that if your cell value is produced by a formula. Only for a constant string.

Regards,

Tom Ogilvy

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Replies (7)

Last updated April 7, 2021 Views 5,119 Applies to: