Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
With interest above need, I tried this and got boxes until I changed font
to Arial Unicode MS. Something the unwary might miss. -- David ?B?R2FyeScncyBTdHVkZW50?= wrote Circled letters are available in unicode. In column A put: 9398 9399 9400 9401 9402 9403 9404 9405 9406 9407 9408 9409 9410 9411 9412 9413 9414 9415 9416 9417 9418 9419 9420 9421 9422 9423 In B1 put: =uni(A1) and copy down Here is the code for uni(): Function uni(r As Range) As String Dim i As Integer Dim s As String i = r.Value s = ChrW(i) uni = s End Function |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort by number not by letter (C1, A2, B3, D4) | Excel Discussion (Misc queries) | |||
Circle on chart different in print preview | Charts and Charting in Excel | |||
linking a cell with a specific letter value to a cell with a formu | Excel Worksheet Functions | |||
fill circle half way | Excel Discussion (Misc queries) | |||
Have A Letter Reference A Name For An Intoduction | New Users to Excel |