How to insert special characters with formula?

[excelos]

Hello!

Can you tell me please how to insert to cells the below characters/format, preferably with a formula as I want to blend them with other text and formulas.

• Dfgdfg
o Fdgdfgdfg
 Fgdfgdfg

if the above don't display correctly, you can get them from MSWord where it is basically the first level bullet point, and then second and third level (after you click ENTER for a new line and TAB for next level bullet point)

Thanks!

 

[ISY]

Hi

    MsgBox Chr(149) & "  Dfgdfg"
    MsgBox ChrW(937) & "  Fdgdfgdfg"
    MsgBox ChrW(1) & "  Fgdfgdfg"

 

[excelos]

Great thanks!
Where do I get the list of all these codes? What is the difference between Char and CharW?

 

[excelos]

These seem to be VBA commands, but I want Excel formulas.

From Word, I get:

2022
006F
F0A7

But how do I convert these into Excel formulas?

 

[ISY]

Hi

Sub TestSquares()
 
Range("A1").Value = ChrW(9679)
Range("A2").Value = ChrW(9675)
Range("A3").Value = ChrW(&H25A1)
Range("A4").Value = ChrW(&H25A0)
 
End Sub

Using Formula:
A5: =A1&A2&" Test"
[TABLE="width: 100"]
<tbody>[TR]
[TD]●[/TD]
[/TR]
[TR]
[TD]○[/TD]
[/TR]
[TR]
[TD]□[/TD]
[/TR]
[TR]
[TD]■[/TD]
[/TR]
[TR]
[TD]●○ Test[/TD]
[/TR]
</tbody>[/TABLE]

 

[excelos]

Hi

Sub TestSquares()
 
Range("A1").Value = ChrW(9679)
Range("A2").Value = ChrW(9675)
Range("A3").Value = ChrW(&H25A1)
Range("A4").Value = ChrW(&H25A0)
 
End Sub

Using Formula:
A5: =A1&A2&" Test"
[TABLE="width: 100"]
<tbody>[TR]
[TD]●[/TD]
[/TR]
[TR]
[TD]○[/TD]
[/TR]
[TR]
[TD]□[/TD]
[/TR]
[TR]
[TD]■[/TD]
[/TR]
[TR]
[TD]●○ Test[/TD]
[/TR]
</tbody>[/TABLE]

Thanks but I need formulas not VBA.

 

[Fluff]

How about

Excel 2013 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

C​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]=UNICHAR(9679) & " " &A7[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]=UNICHAR(9675) & " " &A8[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]=UNICHAR(9632)&" "&A9[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Cover[/td][/tr][/table]

 

[excelos]

How about

Excel 2013 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

C​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]=UNICHAR(9679) & " " &A7[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]=UNICHAR(9675) & " " &A8[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]=UNICHAR(9632)&" "&A9[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Cover[/td][/tr][/table]

That's great, apart from the last which is a black square, while I want white square.

Also, can you tell me please how to get these numbers when the only thing I have is the character in a Word document?

Thanks

 

[Fluff]

For a white square use 9633 rather than 9632
To get the character numbers, I just used the Symbol feature on the Insert Tab, looked for the relevant symbol, copied that into a cell & then used =UNICODE(A1) to get the number