+ Reply to Thread
Results 1 to 2 of 2

Formula to determine which letter is shown in a cell

  1. #1
    Registered User
    Join Date
    12-30-2014
    Location
    Columbus, OH
    MS-Off Ver
    Office 2010
    Posts
    44

    Formula to determine which letter is shown in a cell

    Good morning,
    I've stumbled across a hurdle I don't know how to clear.
    I'm using the following formula to output a lot code into a cell.
    Please Login or Register  to view this content.
    If you'll take notice, the letter "B" is right smack-dab in the middle. I've come across a scenario that I might need it to substitute an "S" for the "B".
    Example output:
    C17MAR2015 B107 --- this is how 99% of our documents need to look. However, we are quickly going to need this document to have the code like this:
    C17MAR2015 S107 --- is it possible to use a check-box form control to actively select the B or S?

    Please Login or Register  to view this content.
    I've been using this line of code and a check box to make the text "Rush Testing Requested" show up or not. Can that type of code me integrated into my lot code formula?

    something like: ="C"&UPPER(TEXT(I9,"DDMMMYYYY"))&" "&"IF('Batch Review Checklist'!J11=TRUE,"S","")"&'Print Control'!D8 -- I know this won't work as is because I'm sure how to create the argument where, by default, false would = "B".
    Any thoughts?
    Thanks!

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Formula to determine which letter is shown in a cell

    Change
    Please Login or Register  to view this content.
    To
    Please Login or Register  to view this content.
    That should give a value of B if false
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula for providing value if value is shown in other cell
    By Stromming in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-26-2014, 10:41 AM
  2. formula SHOWN in one cell, the result in another
    By jaSam in forum Excel General
    Replies: 7
    Last Post: 09-29-2010, 02:56 AM
  3. Replies: 1
    Last Post: 04-05-2010, 02:08 AM
  4. [SOLVED] How to determine the column letter from Cell address
    By Jean in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-23-2006, 10:05 PM
  5. [SOLVED] how to get the formula shown in linked cell's names
    By EXCEL NEWS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-08-2005, 09:05 AM

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