+ Reply to Thread
Results 1 to 2 of 2

Decode the Cells

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    New delhi
    MS-Off Ver
    Excel 2007
    Posts
    50

    Decode the Cells

    HI

    I have working sheet wherein the task is given to decode the values to find a hidden word, as I am not aware about the decoding so just seeking help to understand

    Attached is the excel sheet for reference
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2024
    Posts
    6,176

    Re: Decode the Cells

    Try this in B10 and copy down:

    =RIGHT(A10)&VLOOKUP(MID(A10,3,1)&MID(A10,2,1),$N$3:$O$7,2,0)&LEFT(A10)

    B17:

    =B10&B11&B12&B13&B14

+ 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. [SOLVED] Is there a formula to decode URL's?
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 12-14-2021, 01:15 AM
  2. [SOLVED] msgpack decode in VBA
    By JasperD in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-29-2015, 10:58 AM
  3. Macro to identify cells with info, decode the same and create new table.
    By anagouveia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2015, 02:40 PM
  4. Scramble Text and Decode
    By unclejemima in forum Excel General
    Replies: 6
    Last Post: 08-16-2015, 09:14 AM
  5. Replies: 4
    Last Post: 06-12-2013, 10:28 AM
  6. [SOLVED] serial number decode
    By chiuinggum in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-13-2006, 04:20 AM
  7. Decode MP3 ID3v2 and WMA tag info
    By Tom D in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-18-2005, 10:06 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