Conditional Formatting / Macro to affect specific string within a cell

Hi there

In my excel document I have lots of different entries that contain string that end with the word 'cycle'.
I need to find a way to make these cells such that everything before the word 'cycle' remains as normal, whereas the word 'cycle' gets superscripted.

The string I need to superscript is always the same, its only ever the word cycle that needs to be superscripted.
I dont want to superscript the whole cell, just a part of the text within it.

There doesnt seem to be a quick shortcut key to superscript text, so instead I presume I need to use either conditional formatting or set up a macro to find any text within the currently highlighted cell that matches ' cycle' and superscript that specific bit of text.

I have no idea how to do either though.

Could someone help?

Thanks.

Try

Please Login or Register  to view this content.

After reading your post again it appears you are just superscripting 1 cell. Can you not just highlight the text and select superscript (under fonts)?