Anyway to discern Japanese character fonts in cells and format only those?

[soar2011]

Hi all,

I have a big excell sheet which has many many Japanese / Chinese fonts sprinkled over to many cells. Is there a way or formula to find, select, and increase font size of these characters WHILE leaving the english text fonts in the same cells untouched?

In any cell, a size 10 Arial english text is readable, while Japanese kanji is not or too small. An example: 禦. I want to make them be size 14 which looks like 禦

Manually doing it will require months of chore. Is there a way to do this?

Thank you all.

 

[AD_Taylor]

No problem glad it's working for you. Didn't realise there were so many characters!

 

[ZVI]

The same font – the different algorithm
It's nice that you have worked this task out!