Results 1 to 9 of 9

Simplify text from range of text options

Threaded View

  1. #1
    Registered User
    Join Date
    09-13-2012
    Location
    Edinburgh, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    3

    Simplify text from range of text options

    A cell contains either "Yes", "Yes +Comment", "No", "No + Comment", "Comment only", or "No response"
    I want to summarise these, so that the neighbouring cell will contain Yes, No, or No response ie.

    "Yes" or "Yes +Comment" = "Yes"
    "No" or "No + Comment" = "No"
    "Comment only" or "No response" = "No response".

    Help please, Linda
    Last edited by lindaroslin; 09-14-2012 at 01:02 AM.

Thread Information

Users Browsing this Thread

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

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