Spell check - exclude subscript/superscript words

[Formula11]

Is it possible to carry out a spell check which excludes words which have a subscript or superscript?

This would be for an Excel workbook which contains formulas, etc. such as shown below.

 

[zero269]

Is it possible to carry out a spell check which excludes words which have a subscript or superscript?

This would be for an Excel workbook which contains formulas, etc. such as shown below.

View attachment 104521

I ran a test in my Excel (v365) using superscript and subscripts.
When I ran the spell check (F7), it didn't find any spelling issues:

However, when I added Spellling - separate from the first part with the super/subscripts, those were flagged is misspelled.

See if you have any spaces between the word and super/subscripts.

When I added a space between them, they were flagged as the super /subscripts were now on their own.

Before Spellcheck:

After Spellcheck:

Try this in a new sheet if needed and see if you get the same restuls.
Also check to make sure they are actual super/subscripts using the Font Settings (CTRL + SHIFT + D) [Format Cells] dialog box:

Highlight just the superscript > CTRL + SHIFT + D

Hopefully this helps a little...

 

[Formula11]

Thanks for looking into, I think your result is by selecting "Ignore words that contain numbers" in the Options/Proofing section.

Which is an option, but would miss words that are not supposed to have digits.

 

[zero269]

Thanks for looking into, I think your result is by selecting "Ignore words that contain numbers" in the Options/Proofing section.

Which is an option, but would miss words that are not supposed to have digits.

Good catch! I didn't realize that earlier.
I shouldn't be surprised that Microsoft hasn't addressed this issue... ever. Seems like it should be an available option.

I found this online just now. It specifically addressed this issue. It's related to Word, but it's a Macro solution. So it would obviously need to be tested in Excel. There's a video there as well if you want to see it in action.

Spellchecking Words with Superscripts

Adding a superscript to a word is necessary for many types of writing. Doing so, however, can confuse the spell checker in Word. Here's one way to get around this problem.

wordribbon.tips.net

 

[zero269]

Those macros definitely need to be converted to work in Excel:

The values I found having issues so far were:

• wdFindContinue
• wdReplaceAll
• ActiveDocument.SpellingChecked = False

 

[zero269]

Which is an option, but would miss words that are not supposed to have digits.

And any super/subscripts that are using letters...

I wouldn't mark this thread as resolved yet. There are some really good VBA experts in this forum that could very well find a solution for you, given a little time.

 

[Formula11]

OK thanks I will change to un-resolved.