• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to make a symbol appear in as cell by keying in a predefined word.

I need to use some selected symbols in a workbook for different purposes.
Each symbol will be represented by a word.
If i key in the word 'fwd1' the symbol '->' must appear.
If i key in the word 'fwd2' the symbol '-->>' must appear.
These are only hypothetical symbols.........
In the workbook i will be using the actual symbols provided by Excel but without
having to go thru the hassle of...Insert ->Symbols and then selecting the symbol.
That is time-consuming.
Sheet #1 of the workbook will be the master sheet in which a word & the
corresponding symbol are defined.
Since the symbols will be used frequently in the same workbook and in different worksheets
i thought an Excel formula might do the trick.
Btw....copy/paste may not be an ideal solution in this case since the project involves a number of worksheets. It would be easier to remember a word like 'fwd1' or fwd2' rather than do a
to & fro exercise to figure out the appropriate symbol (if copy/paste is used).
What Excel formula can be used to achieve the desired results???
 
Hi James ,

A simple VLOOKUP will do ; if you define a range where all the words and associated symbols are listed , you can use a formula such as :

=VLOOKUP(A1,SymbolsTable,2,FALSE)

where A1 can contain the word such as fwd1 , fwd2 ,...

Narayan
 
Dear Narayanak sir

As per James question, he wants a symbol to be appeared by pressing the particular key board sequence. So as per your formula, it will show the desired symbol by providing word (A1). So this will one type of helper column to get the symbol.. am i right ??

I want to know that,, can we create a key event that if a particular key words press, then the symbol to be appeared in activecell by VBA ??

Please give your valuable comments on this.. and if there any solution, then please try to explain in a short, so that others can resolve their problem without creating thread....:):):)
 
Hi All,

I think if the problem is only to put a symbol in some pre-defined cells, than better to make a list of all symbols that you intend to put in cells, and than use data validation of list and in source give this range of symbols, than where ever you want symbols you can copy that cell.

Regards,
 
Back
Top