Excel 濁音を含む並び替え順について。in Excel, sort including Japanese voiced sound.

%3CLINGO-SUB%20id%3D%22lingo-sub-3079115%22%20slang%3D%22ja-JP%22%3EAbout%20the%20sort%20order%20including%20Excel%20turbidity%20sound.%20in%20Excel%2C%20sort%20including%20Japanese%20voiced%20sound.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3079115%22%20slang%3D%22ja-JP%22%3E%3CP%3E%3CSTRONG%3E%E2%96%A0Usage%20software%3A%20office365%20Excel%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%E2%96%A0%20Problem%3A%20There%20is%20a%20problem%20with%20Japanese%20sorting%20including%20turbidity%20points.%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%E2%96%A0%20Software%20used%3A%20office365%20Excel%20%3CBR%20%2F%3E%20%E2%96%A0%20Problem%3A%20There%20is%20a%20problem%20with%20Japanese%20sorting%20including%20dakuten.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%E2%96%A0Question%3A%20I%20would%20like%20you%20to%20tell%20us%20about%20the%20order%20of%20sorting%20using%20japanese%20turbid%20sounds%20in%20Excel.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%E2%96%A0%20Question%3A%20I%20would%20like%20to%20know%20the%20sorting%20order%20used%20in%20Excel%2C%20including%20Japanese%20voiced%20sound.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%E2%96%A0%20What%20I%20want%20to%20achieve%3C%2FSTRONG%3E%3CBR%20%2F%3E%20%E3%83%BB%20%3CSTRONG%3EKiyone%20(e.g.%20or%20)%3C%2FSTRONG%3E%3CBR%20%2F%3E%20%3CSTRONG%3E%20%E2%86%93%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%E3%83%BB%20Turbid%20sound%20(e.g.%20)%3C%2FSTRONG%3E%3CBR%20%2F%3E%20I%20want%20to%20realize%20sorting%20in%20such%20%3CSTRONG%3Eorder.%20%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%E2%96%A0%20What%20you%20want%20to%20achieve%20%3CBR%20%2F%3E%20Kiyone%20(example%3A%22Kaisha%20Ie%22%20reading%20%3D%20kaisya%20ie)%20%3CBR%20%2F%3E%20%E2%86%93%20%E3%83%BB%20%3CBR%20%2F%3E%20Voiced%20sound%20(example%3A%22Gaisya%20ai%22%20reading%20%3D%20gaisya%20ai)%20%3CBR%20%2F%3E%20I%20want%20to%20realize%20this%20sorting%20in%20order.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E*%20Supplement%3C%2FSTRONG%3E%3CBR%20%2F%3E%20In%20the%20%3CSTRONG%3Egeneral%20site%20article%20about%20Excel%202007-2010%2C%20it%20was%20excel%20specifications.%20%3C%2FSTRONG%3E%3CBR%20%2F%3E%20%3CSTRONG%3E%22The%20rules%20of%20sorting%20by%20alphabetical%20order%20basically%20do%20not%20distinguish%20between%20pure%2C%20turbid%2C%20and%20semi-turbid.%22%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3EWe%20don't%20know%20if%20we%20can't%20sort%20or%20find%20a%20QA%20for%20turbidity%20on%20our%20official%20website%2C%20so%20we%20can't%20improve%20it%20now%2C%20or%20if%20we%20can%20respond%20to%20it%20by%20setting%20it%20up.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E2%80%BBsupplement%20%3CBR%20%2F%3E%20In%20the%20article%20on%20the%20general%20site%20about%20Excel%202007-2010%2C%20there%20was%20a%20specification%20of%20Excel.%20%3CBR%20%2F%3E%20%22The%20rules%20for%20sorting%20in%20alphabetical%20order%20basically%20do%20not%20distinguish%20between%20seion%2C%20dakuon%2C%20and%20handakuon.%22%3C%2FP%3E%3CP%3EI%20can't%20find%20a%20QA%20about%20sorting%20or%20voiced%20sound%20on%20the%20official%20Microsoft%20website%2C%20so%20please%20tell%20me%20if%20you%20can't%20improve%20it%20even%20now%2C%20or%20if%20you%20can%20handle%20it%20by%20setting%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3079115%22%20slang%3D%22ja-JP%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

■使用ソフト:office365 Excel
■問題:濁点を含む日本語並び替えに不具合がある。

■ Software used: office365 Excel
■ Problem: There is a problem with Japanese sorting including dakuten.

 

 

■質問:Excelで日本語の濁音を含む使用した並び替え順について、教えていただきたいです。

■ Question: I would like to know the sorting order used in Excel, including Japanese voiced sound.

 

■実現したいこと
・清音(例:か)
 ↓
・濁音(例:が)
このような順で並び替えを実現したい。


■ What you want to achieve
・ Kiyone (example:「かいしゃ いえ」reading = kaisya ie)

・ Voiced sound (example:「がいしゃ あい」reading = gaisya ai)
I want to realize sorting in this order.

 

※補足
Excel2007~2010に関する一般サイトの記事では、Excelの仕様とありました。
「五十音順による並べ替えの規則では、基本的に清音、濁音、半濁音の区別をしていない。」

Microsoft公式サイト内で並び替え、または濁音に関するQAが見つからないため、今現在も改善できないのか、または設定などで対応できるのか、ご教授お願いいたします。

 

※supplement
In the article on the general site about Excel 2007-2010, there was a specification of Excel.
"The rules for sorting in alphabetical order basically do not distinguish between seion, dakuon, and handakuon."

I can't find a QA about sorting or voiced sound on the official Microsoft website, so please tell me if you can't improve it even now, or if you can handle it by setting etc.

0 Replies