+ Reply to Thread
Results 1 to 2 of 2

Data input/output

  1. #1
    Registered User
    Join Date
    07-11-2016
    Location
    Riga
    MS-Off Ver
    2010
    Posts
    1

    Data input/output

    Hello,
    I have faced a problem and dont know how to solve it.

    The problem is I wanted to make a excel document that recognize symbol and gives me value that is written down somewhere before. Example:
    Symbol "A" is 225, "B" 230, I need to write down all the letters, each has different value, also "A" and "a" has different values. So what I want to do is, when I enter words (each letter in different cell) it will give me a value that is defined before. I hope wrote it simple enough.

    Next step would be that excel is able to give me a number from two letters, example have written "C A T", it will understand the symbols C and A, and A; T and will give me value that is defined before.

    The thing is I am trying to make an excel file that will calculate widths of words, each letter has different width, and different letters have different gap sizes between them.

    If anyone has any ideas, please let me know.

    Janis

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,038

    Re: Data input/output

    Enter the symbols and values in a table, then use VLOOKUP to bring back the correct symbol.
    Changine the font to Courier New will maintain the same width though it's not an attractive font.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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. Replies: 3
    Last Post: 09-15-2015, 06:07 AM
  2. formula: data in output cell is not changing when data in input cells are modified
    By Kuttisankaran in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-07-2013, 05:58 AM
  3. Replies: 7
    Last Post: 05-09-2012, 04:44 AM
  4. Input/Output Data
    By BabyDoc in forum Excel General
    Replies: 3
    Last Post: 08-23-2011, 09:51 PM
  5. Data Input/Output Question
    By michael.cholko in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2011, 04:21 AM
  6. Form to output input data into spreadsheet
    By kronos in forum Excel General
    Replies: 1
    Last Post: 06-23-2010, 01:03 PM
  7. Replies: 1
    Last Post: 06-23-2010, 07:08 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