【练习】截取-字符前的字符串【练习已汇总并发布原创】

象山海鲜

cinlo 发表于 2021-5-6 16:29
是不是要给表里的人发奖？？

都已经加过财富了！
能低于24字符可以+1技术分

cinlo

象山海鲜 发表于 2021-5-6 16:34
都已经加过财富了！
能低于24字符可以+1技术分

这得找微软的开发人员做点事了。

jianyang11

期待大神佳作
=LEFT(C2,MATCH(45,CODE(MID(C2,ROW($1:$99),1)),)-1)

隔扣五人

我在见证历史

李逸雪

太强了，膜拜

@刘卓

text第二参数中带【】的看不懂

轩檐

膜拜一下海鲜老师，研究的真深。顺便问下老师，为何409和804的年份都是一样，其他可以不一样呢，也是语言环境的问题吗？比如说：[img][/img]
在回复被抓的时候，我知道了不同，用=TEXT(NOW(),"[$-1E020404]mmmm dd yyyy")，就可以出来结果。

这个应该是代码

01 = Western language02 = Arabic Hindi03 = Extend Arabic Hindi04 = Sanskrit05 = Bengali06 = Gorumuchi07 = Gujarati08 = Oriya09 = Tamil0A = Telugu0B = Kannada0C = Malayalam0D = Thai0E = Laotian0F = Tibetan language10 = Burmese11 = Ethiopian12 = Cambodian13 = Mongolian1B = Japanese 11C = Japanese 21D = Japanese 31E = Simplified Chinese 1, Chinese lowercase1F = Simplified Chinese 2, Chinese uppercase20 = Simplified Chinese 3, full-width numbers21 = Traditional Chinese 1, traditional lowercase22 = Traditional Chinese 2, traditional uppercase23 = Traditional Chinese 3, full-width numbers24 = Korean 125 = Korean 226 = Korean 327 = Korean 4++++++++++++++++++++++++++++++++++01 = Gregorian calendar (localization)02 = Gregorian calendar (United States)03 = Japanese calendar (and calendar)04 = Taiwan calendar05 = Korean calendar (Tanji)06 = Hajj (Arab Lunar Calendar)07 = Thai08 = Jewish Calendar09 = Gregorian calendar (Middle Eastern French)11 = Lunar Calendar (Not Officially published)12 = Lunar Calendar (Not Officially published)13 = Lunar Calendar (Not Officially published)0A = Gregorian calendar (Arabic)0B = Gregorian calendar (translated English)0E = Lunar Calendar (Not Officially published)+++++++++++++++++++++++++0401 = Arabic = 10250402 = Bulgarian = 10260403 = Catalan = 10270404 = traditional Chinese) = 10280405 = Czech = 10290406 = Danish = 10300407 = German = 10310408 = Greek = 10320409 = English (United States) = 1033040B = Finnish = 1035040C = French = 1036040D = Hebrew = 1037040E = Hungarian = 1038040F = Icelandic = 10390410 = Italian = 10400411 = Japanese = 10410412 = Korean = 10420413 = Dutch = 10430414 = Norwegian (Birkmer) = 10440415 = Polish = 10450416 = Portuguese (Brazil) = 10460418 = Romanian = 10480419 = Russian = 1049041A = Croatian = 1050041B = Slovak = 1051041C = Albanian = 1052041D = Swedish = 1053041E = Thai = 1054041F = Turkish = 10550420 = Urdu = 10560421 = Indonesian = 10570422 = Ukrainian = 10580423 = Belarusian = 10590424 = Slovenian = 10600425 = Estonian = 10610426 = Latvian = 10620427 = Lithuanian = 10630428 = Tajik = 10640429 = Persian = 1065042A = Vietnamese = 1066042B = Armenian = 1067042C = Azerbaijani (Latin) = 1068042D = Basque = 1069042F = Macedonian = 10710436 = Afrikaans = 10780437 = Georgian = 10790438 = Faroese = 10800439 = Hindi = 1081043A = Maltese = 1082043D = Yiddish = 1085043E = Malay = 1086043F = Kazakh = 10870440 = Kyrgyz = 10880441 = Swahili = 10890442 = Turkmen = 10900443 = Uzbek (Latin) = 10910444 = Proverb = 10920445 = Bengali = 10930446 = Punjabi = 10940447 = Gujarati = 10950448 = Oriya = 10960449 = Tamil = 1097044A = Telugu = 1098044B = Kannada = 1099044C = Malayalam = 1100044D = Assamese = 1101044E = Marathi = 1102044F = Sanskrit = 11030450 = Mongolian = 11040456 = Galician = 11100457 = Gungan = 11110458 = Manipur = 11120459 = Sindhi = 1113045A = Syrian = 1114045B = Sinhalese = 1115045C = Congga = 1116045D = Inuit = 1117045E = Amharic = 1118045F = Tamasic (Berber / Arab) = 11190460 = Kashmiri (Arabic) = 11200461 = Nepali = 11210462 = Frisian = 11220463 = Pashto = 11230464 = Filipino = 11240465 = Dhivehi = 11250466 = Kwa = 11260467 = Furbe = 11270468 = Hausa = 11280469 = Ibibio = 1129046A = Yoruba = 11300470 = Igbo = 11360471 = Kanuri = 11370472 = Kucht = 11380473 = Tigrinya (Ethiopia) = 11390475 = Hawaiian = 11410476 = Latin = 11420477 = Somali = 11430478 = Proverb = 11440804 = Chinese (Simplified) = 20520807 = German (Switzerland) = 20550809 = English (UK) = 20570814 = Norwegian (Nynorsk) = 20680816 = Portuguese (Portugal) = 2070081A = Serbian (Latin) = 2074082C = Azeri (Cyrillic) = 20920843 = Uzbek (Cyrillic) = 21150873 = Tigrinya (Eritrea) = 2163085F = Tamasic (Latin) = 21430C07 = German (Austria) = 30790C09 = English (Australia) = 30810C0A = Spanish = 30820C0C = French (Canada) = 30840C1A = Serbian (Cyrillic) = 30981009 = English (Canada) = 4105+++++++++++++++++++++++++++++++++++++所以，=TEXT(NOW(),"[$-1E020404]mmmm dd yyyy")的结果是May ○七 二○二一

小書生

象山海鲜 发表于 2021-5-6 16:18
一、统计

第一个《 - 》后面只能是单字节字符(数字 字母等）

有两个特例：-后边不能直接跟-或者,（半角逗号或减号）；
1、一个逗号不行，多个就可以，或者加其他符号可以；
2、一个减号不行，多个也不行，紧邻第一个减号后边不能为减号；

[$--]、[$-------]不行
[$-,] 不行 [$-,,]可以

象山海鲜

小書生 发表于 2021-5-7 16:38
第一个《 - 》后面只能是单字节字符(数字 字母等）

有两个特例：-后边不能直接跟-或者,（半角逗号或减 ...

谢谢 测试完善

李逸雪 也有完善大部分情况，请查看帖子
海鲜的TEXT测试
http://club.excelhome.net/thread-1584215-1-1.html

cinlo

好好学习，天天向上，谢谢海鲜版主！！！