Results 1 to 5 of 5

Conditional Formatting / Macro to affect specific string within a cell

Threaded View

  1. #1
    Registered User
    Join Date
    09-10-2012
    Location
    Guildford, UK
    MS-Off Ver
    Excel 2003
    Posts
    23

    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.
    Last edited by xandermacleod; 12-16-2012 at 02:05 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1