AUNICHAR

=AUNICHAR(st,r,c,sh)
st
integer, start unicode value
r
integer, number of rows
c
integer, number of columns
sh
show argument, 0 or ignored does not show unicode value next to the icon, 1 shows unicode values next to the icon
function to visualize icons, emojis or symbols next to their Unicode values
Xlambda

Xlambda

Well-known Member
Joined
Mar 8, 2021
Messages
832
Office Version
  1. 365
Platform
  1. Windows
AUNICHAR Array Unichar, function to visualize icons, emojis or symbols next to their Unicode values. (Useful for choosing other icons for your ACALENDAR lambda icons set)
Excel Formula: 
=LAMBDA(st,r,c,sh,
    LET(s,SEQUENCE(r,c,st),u,UNICHAR(s),
       IF(OR(sh={0,1}),IF(sh,u&" "&s,u),"show value 0 or 1")
    )
)
AUNICHAR.xlsx
ABCDEFGHIJKLMNOPQRSTUVWX
1=AUNICHAR(B2,B3,B4,B5)Note: Icons not colored in real spreadsheet
2start127740? 127740? 127741? 127742? 127743? 127744? 127745? 127746? 127747? 127748? 127749? 127750? 127751? 127752? 127753? 127754? 127755? 127756? 127757? 127758? 127759
3rows50? 127760? 127761? 127762? 127763? 127764? 127765? 127766? 127767? 127768? 127769? 127770? 127771? 127772? 127773? 127774? 127775? 127776? 127777? 127778? 127779
4clms20? 127780? 127781? 127782? 127783? 127784? 127785? 127786? 127787? 127788? 127789? 127790? 127791? 127792? 127793? 127794? 127795? 127796? 127797? 127798? 127799
5show1? 127800? 127801? 127802? 127803? 127804? 127805? 127806? 127807? 127808? 127809? 127810? 127811? 127812? 127813? 127814? 127815? 127816? 127817? 127818? 127819
6end128739? 127820? 127821? 127822? 127823? 127824? 127825? 127826? 127827? 127828? 127829? 127830? 127831? 127832? 127833? 127834? 127835? 127836? 127837? 127838? 127839
7? 127840? 127841? 127842? 127843? 127844? 127845? 127846? 127847? 127848? 127849? 127850? 127851? 127852? 127853? 127854? 127855? 127856? 127857? 127858? 127859
8icons sections? 127860? 127861? 127862? 127863? 127864? 127865? 127866? 127867? 127868? 127869? 127870? 127871? 127872? 127873? 127874? 127875? 127876? 127877? 127878? 127879
9startend? 127880? 127881? 127882? 127883? 127884? 127885? 127886? 127887? 127888? 127889? 127890? 127891? 127892? 127893? 127894? 127895? 127896? 127897? 127898? 127899
10820011840? 127900? 127901? 127902? 127903? 127904? 127905? 127906? 127907? 127908? 127909? 127910? 127911? 127912? 127913? 127914? 127915? 127916? 127917? 127918? 127919
11119801120840? 127920? 127921? 127922? 127923? 127924? 127925? 127926? 127927? 127928? 127929? 127930? 127931? 127932? 127933? 127934? 127935? 127936? 127937? 127938? 127939
12127221129700? 127940? 127941? 127942? 127943? 127944? 127945? 127946? 127947? 127948? 127949? 127950? 127951? 127952? 127953? 127954? 127955? 127956? 127957? 127958? 127959
13? 127960? 127961? 127962? 127963? 127964? 127965? 127966? 127967? 127968? 127969? 127970? 127971? 127972? 127973? 127974? 127975? 127976? 127977? 127978? 127979
14win key+ . (emojis)? 127980? 127981? 127982? 127983? 127984? 127985? 127986? 127987? 127988? 127989? 127990? 127991? 127992? 127993? 127994? 127995? 127996? 127997? 127998? 127999
15has 6 tabs? 128000? 128001? 128002? 128003? 128004? 128005? 128006? 128007? 128008? 128009? 128010? 128011? 128012? 128013? 128014? 128015? 128016? 128017? 128018? 128019
16first upper left? 128020? 128021? 128022? 128023? 128024? 128025? 128026? 128027? 128028? 128029? 128030? 128031? 128032? 128033? 128034? 128035? 128036? 128037? 128038? 128039
17last lower right? 128040? 128041? 128042? 128043? 128044? 128045? 128046? 128047? 128048? 128049? 128050? 128051? 128052? 128053? 128054? 128055? 128056? 128057? 128058? 128059
18of each tab? 128060? 128061? 128062? 128063? 128064? 128065? 128066? 128067? 128068? 128069? 128070? 128071? 128072? 128073? 128074? 128075? 128076? 128077? 128078? 128079
19? 128080? 128081? 128082? 128083? 128084? 128085? 128086? 128087? 128088? 128089? 128090? 128091? 128092? 128093? 128094? 128095? 128096? 128097? 128098? 128099
20tab 1? 128100? 128101? 128102? 128103? 128104? 128105? 128106? 128107? 128108? 128109? 128110? 128111? 128112? 128113? 128114? 128115? 128116? 128117? 128118? 128119
21?128512? 128120? 128121? 128122? 128123? 128124? 128125? 128126? 128127? 128128? 128129? 128130? 128131? 128132? 128133? 128134? 128135? 128136? 128137? 128138? 128139
22??‍?‍??128104? 128140? 128141? 128142? 128143? 128144? 128145? 128146? 128147? 128148? 128149? 128150? 128151? 128152? 128153? 128154? 128155? 128156? 128157? 128158? 128159
23tab 2? 128160? 128161? 128162? 128163? 128164? 128165? 128166? 128167? 128168? 128169? 128170? 128171? 128172? 128173? 128174? 128175? 128176? 128177? 128178? 128179
24?128105? 128180? 128181? 128182? 128183? 128184? 128185? 128186? 128187? 128188? 128189? 128190? 128191? 128192? 128193? 128194? 128195? 128196? 128197? 128198? 128199
25?128133? 128200? 128201? 128202? 128203? 128204? 128205? 128206? 128207? 128208? 128209? 128210? 128211? 128212? 128213? 128214? 128215? 128216? 128217? 128218? 128219
26tab 3? 128220? 128221? 128222? 128223? 128224? 128225? 128226? 128227? 128228? 128229? 128230? 128231? 128232? 128233? 128234? 128235? 128236? 128237? 128238? 128239
27?127880? 128240? 128241? 128242? 128243? 128244? 128245? 128246? 128247? 128248? 128249? 128250? 128251? 128252? 128253? 128254? 128255? 128256? 128257? 128258? 128259
28?128368? 128260? 128261? 128262? 128263? 128264? 128265? 128266? 128267? 128268? 128269? 128270? 128271? 128272? 128273? 128274? 128275? 128276? 128277? 128278? 128279
29tab 4? 128280? 128281? 128282? 128283? 128284? 128285? 128286? 128287? 128288? 128289? 128290? 128291? 128292? 128293? 128294? 128295? 128296? 128297? 128298? 128299
30?127829? 128300? 128301? 128302? 128303? 128304? 128305? 128306? 128307? 128308? 128309? 128310? 128311? 128312? 128313? 128314? 128315? 128316? 128317? 128318? 128319
31?127811? 128320? 128321? 128322? 128323? 128324? 128325? 128326? 128327? 128328? 128329? 128330? 128331? 128332? 128333? 128334? 128335? 128336? 128337? 128338? 128339
32tab 5? 128340? 128341? 128342? 128343? 128344? 128345? 128346? 128347? 128348? 128349? 128350? 128351? 128352? 128353? 128354? 128355? 128356? 128357? 128358? 128359
33?128663? 128360? 128361? 128362? 128363? 128364? 128365? 128366? 128367? 128368? 128369? 128370? 128371? 128372? 128373? 128374? 128375? 128376? 128377? 128378? 128379
34?127754? 128380? 128381? 128382? 128383? 128384? 128385? 128386? 128387? 128388? 128389? 128390? 128391? 128392? 128393? 128394? 128395? 128396? 128397? 128398? 128399
35tab 6? 128400? 128401? 128402? 128403? 128404? 128405? 128406? 128407? 128408? 128409? 128410? 128411? 128412? 128413? 128414? 128415? 128416? 128417? 128418? 128419
36❤10084? 128420? 128421? 128422? 128423? 128424? 128425? 128426? 128427? 128428? 128429? 128430? 128431? 128432? 128433? 128434? 128435? 128436? 128437? 128438? 128439
37?128359? 128440? 128441? 128442? 128443? 128444? 128445? 128446? 128447? 128448? 128449? 128450? 128451? 128452? 128453? 128454? 128455? 128456? 128457? 128458? 128459
38? 128460? 128461? 128462? 128463? 128464? 128465? 128466? 128467? 128468? 128469? 128470? 128471? 128472? 128473? 128474? 128475? 128476? 128477? 128478? 128479
39win key+ . (symbols)? 128480? 128481? 128482? 128483? 128484? 128485? 128486? 128487? 128488? 128489? 128490? 128491? 128492? 128493? 128494? 128495? 128496? 128497? 128498? 128499
40? 128500? 128501? 128502? 128503? 128504? 128505? 128506? 128507? 128508? 128509? 128510? 128511? 128512? 128513? 128514? 128515? 128516? 128517? 128518? 128519
41tab 1? 128520? 128521? 128522? 128523? 128524? 128525? 128526? 128527? 128528? 128529? 128530? 128531? 128532? 128533? 128534? 128535? 128536? 128537? 128538? 128539
42(40? 128540? 128541? 128542? 128543? 128544? 128545? 128546? 128547? 128548? 128549? 128550? 128551? 128552? 128553? 128554? 128555? 128556? 128557? 128558? 128559
43※8251? 128560? 128561? 128562? 128563? 128564? 128565? 128566? 128567? 128568? 128569? 128570? 128571? 128572? 128573? 128574? 128575? 128576? 128577? 128578? 128579
44tab 2? 128580? 128581? 128582? 128583? 128584? 128585? 128586? 128587? 128588? 128589? 128590? 128591? 128592? 128593? 128594? 128595? 128596? 128597? 128598? 128599
45$36? 128600? 128601? 128602? 128603? 128604? 128605? 128606? 128607? 128608? 128609? 128610? 128611? 128612? 128613? 128614? 128615? 128616? 128617? 128618? 128619
46₾8382? 128620? 128621? 128622? 128623? 128624? 128625? 128626? 128627? 128628? 128629? 128630? 128631? 128632? 128633? 128634? 128635? 128636? 128637? 128638? 128639
47tab 3? 128640? 128641? 128642? 128643? 128644? 128645? 128646? 128647? 128648? 128649? 128650? 128651? 128652? 128653? 128654? 128655? 128656? 128657? 128658? 128659
48A65? 128660? 128661? 128662? 128663? 128664? 128665? 128666? 128667? 128668? 128669? 128670? 128671? 128672? 128673? 128674? 128675? 128676? 128677? 128678? 128679
49ʭ685? 128680? 128681? 128682? 128683? 128684? 128685? 128686? 128687? 128688? 128689? 128690? 128691? 128692? 128693? 128694? 128695? 128696? 128697? 128698? 128699
50tab 4? 128700? 128701? 128702? 128703? 128704? 128705? 128706? 128707? 128708? 128709? 128710? 128711? 128712? 128713? 128714? 128715? 128716? 128717? 128718? 128719
51←8592? 128720? 128721? 128722? 128723? 128724? 128725? 128726? 128727? 128728? 128729? 128730? 128731? 128732? 128733? 128734? 128735? 128736? 128737? 128738? 128739
52◮9710
53tab 5
54⁰8304
55⑨9320
56tab 6
57❤10084
58?128359
59
AUNICHAR post
Cell Formulas
RangeFormula
D1D1=FORMULATEXT(D2)
D2:W51D2=AUNICHAR(B2,B3,B4,B5)
B6B6=B2+B3*B4-1
B21:B22,B57:B58,B54:B55,B51:B52,B48:B49,B45:B46,B42:B43,B36:B37,B33:B34,B30:B31,B27:B28,B24:B25B21=UNICODE(A21)
Dynamic array formulas.
 
Upvote 0
I like it :)

By the way, icons are colored on Mac.
1620307971298.png
 
Thanks!! Good to know, another advantage for Mac users. :).
 
Refined function, same arguments, same functionality, show argument "sh" can be omitted now.
This function was a life saver in helping me "shopping" for Xmas tree's ornaments, selecting sections of the vast Unicode characters table. AXMAS
AUNICHAR(st,r,c,[sh])
Excel Formula: 
=LAMBDA(st,r,c,[sh],LET(s,SEQUENCE(r,c,st),u,UNICHAR(s),SWITCH(sh,0,u,1,u&" "&s)))
AXMAS.xlsx
ABCDEFGHIJKLMNOPQRSTUVW
1
2chessboard pieces, card deck suitsnumbers as globes
3=AUNICHAR(9812,7,4,1)=AUNICHAR(9312,40,4,1)=AUNICHAR(127744,40,4)=AUNICHAR(127760,40,4)
4♔ 9812♕ 9813♖ 9814♗ 9815① 9312② 9313③ 9314④ 9315????????various "starting" points
5♘ 9816♙ 9817♚ 9818♛ 9819⑤ 9316⑥ 9317⑦ 9318⑧ 9319????????♔9812
6♜ 9820♝ 9821♞ 9822♟ 9823⑨ 9320⑩ 9321⑪ 9322⑫ 9323????????①9312
7♠ 9824♡ 9825♢ 9826♣ 9827⑬ 9324⑭ 9325⑮ 9326⑯ 9327?????????127744
8♤ 9828♥ 9829♦ 9830♧ 9831⑰ 9328⑱ 9329⑲ 9330⑳ 9331?????????129293
9♨ 9832♩ 9833♪ 9834♫ 9835⑴ 9332⑵ 9333⑶ 9334⑷ 9335?????????120016
10♬ 9836♭ 9837♮ 9838♯ 9839⑸ 9336⑹ 9337⑺ 9338⑻ 9339?????????120172
11⑼ 9340⑽ 9341⑾ 9342⑿ 9343????????①9312
12letters⒀ 9344⒁ 9345⒂ 9346⒃ 9347????????❶10102
13=AUNICHAR(120016,20,4,1)⒄ 9348⒅ 9349⒆ 9350⒇ 9351?????????120042
14? 120016? 120017? 120018? 120019⒈ 9352⒉ 9353⒊ 9354⒋ 9355?????????120812
15? 120020? 120021? 120022? 120023⒌ 9356⒍ 9357⒎ 9358⒏ 9359?????????127760
16? 120024? 120025? 120026? 120027⒐ 9360⒑ 9361⒒ 9362⒓ 9363????????
17? 120028? 120029? 120030? 120031⒔ 9364⒕ 9365⒖ 9366⒗ 9367????????
18? 120032? 120033? 120034? 120035⒘ 9368⒙ 9369⒚ 9370⒛ 9371????????
19? 120036? 120037? 120038? 120039⒜ 9372⒝ 9373⒞ 9374⒟ 9375????????
20? 120040? 120041? 120042? 120043⒠ 9376⒡ 9377⒢ 9378⒣ 9379????????
21? 120044? 120045? 120046? 120047⒤ 9380⒥ 9381⒦ 9382⒧ 9383????????
22? 120048? 120049? 120050? 120051⒨ 9384⒩ 9385⒪ 9386⒫ 9387????????
23? 120052? 120053? 120054? 120055⒬ 9388⒭ 9389⒮ 9390⒯ 9391????????
24? 120056? 120057? 120058? 120059⒰ 9392⒱ 9393⒲ 9394⒳ 9395????????
25? 120060? 120061? 120062? 120063⒴ 9396⒵ 9397Ⓐ 9398Ⓑ 9399????????
26? 120064? 120065? 120066? 120067Ⓒ 9400Ⓓ 9401Ⓔ 9402Ⓕ 9403????????
27? 120068? 120069? 120070? 120071Ⓖ 9404Ⓗ 9405Ⓘ 9406Ⓙ 9407????????
28? 120072? 120073? 120074? 120075Ⓚ 9408Ⓛ 9409Ⓜ 9410Ⓝ 9411????????
29? 120076? 120077? 120078? 120079Ⓞ 9412Ⓟ 9413Ⓠ 9414Ⓡ 9415????????
30? 120080? 120081? 120082? 120083Ⓢ 9416Ⓣ 9417Ⓤ 9418Ⓥ 9419????????
31? 120084? 120085? 120086? 120087Ⓦ 9420Ⓧ 9421Ⓨ 9422Ⓩ 9423????????
32? 120088? 120089? 120090? 120091ⓐ 9424ⓑ 9425ⓒ 9426ⓓ 9427????????
33? 120092? 120093? 120094? 120095ⓔ 9428ⓕ 9429ⓖ 9430ⓗ 9431????????
34ⓘ 9432ⓙ 9433ⓚ 9434ⓛ 9435????????
35ⓜ 9436ⓝ 9437ⓞ 9438ⓟ 9439????????
36ⓠ 9440ⓡ 9441ⓢ 9442ⓣ 9443????????
37ⓤ 9444ⓥ 9445ⓦ 9446ⓧ 9447????????
38ⓨ 9448ⓩ 9449⓪ 9450⓫ 9451????????
39⓬ 9452⓭ 9453⓮ 9454⓯ 9455????????
40⓰ 9456⓱ 9457⓲ 9458⓳ 9459????????
41⓴ 9460⓵ 9461⓶ 9462⓷ 9463????????
42⓸ 9464⓹ 9465⓺ 9466⓻ 9467????????
43⓼ 9468⓽ 9469⓾ 9470⓿ 9471????????
44
AUNICHAR ornaments
Cell Formulas
RangeFormula
A3,A13,K3,P3,F3A3=FORMULATEXT(A4)
A4:D10A4=AUNICHAR(9812,7,4,1)
F4:I43F4=AUNICHAR(9312,40,4,1)
K4:N43K4=AUNICHAR(127744,40,4)
P4:S43P4=AUNICHAR(127760,40,4)
A14:D33A14=AUNICHAR(120016,20,4,1)
V5:V15V5=UNICODE(U5)
Dynamic array formulas.
 
You must log in or register to reply here.

Forum statistics

Threads
1,216,149
Messages
6,129,149
Members
449,488
Latest member
qh017

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top