EXAMPLE, IF I TYPE "FE" Then automatically fill in one cell as FRIEND, Another one cell to be fill ENIMIY, I want keep shortcut "FE" in autocorrect function.
EXAMPLE, IF I TYPE "FE" Then automatically fill in one cell as FRIEND, Another one cell to be fill ENIMIY, I want keep shortcut "FE" in autocorrect function.
Last edited by vengatvj; 10-04-2013 at 05:12 PM.
Not sure if I understand you correctly, but if you want to type FE in 1 cell (say A1), then in another cell (say B1) you want it to say FRIEND, then try this, copied down...
=if(A1="FE","FRIEND","Enemy")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
am talking about autocorrect function,tools-proofing-autocorrect. I want make a keyword for 2 words, if i type that keyword then 1 word should b in one cel, another 1 word should b in second cel.
That won't work. Autocorrect will only work in the active cell as you are entering data.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
oh, ok if be like that as i told will b better, easy to enter continues datas instead of typing, again and again. Is there anyother option?
You could create a two column list. The first column would have a "short form" and the second column would have what the short form stood for. This would the be accessed with VLOOKUP or INDEX MATCH formulae in the cells that you want to hold the data...not the cell where you are entering the short form as this would over-write any formula in the cell.
More information is required before a "real" solution can be offered.
Can you create a dummy sheet of what you expect and upload it so that the problem becomes more clear?
hi newdoverman, i attached some example files. pls find and tell me
What you want might be possible using VBA but I don't think that it is possible using worksheet functions. The closest that you can come is something like this:
YA.. i thought also like this your formula.. but problem is many functions is there. , already my excel getting slow..now am reducing unwanted lookup, columns, your idea is so good, i will try if i need like this way..
HI ANYONE KNOW AUTOCORRECT WORDS FILL IN TWO OR THREE CELLS WHEN TYPING IN ONE CELL, I HAVE GIVEN EXAMPLE EXCEL FILE., KINDLY SEE AND TELL ME THE SOLUTION, OR ANY OTHER WAY IS THERE MEANS TELL ME PLS,
if i type "AB" in cell A1 THEN its will replace as i assumed, it should be change like this, A1 cell should display "apple" B1 cell is display "ball", i make "ab" shortcut for apple and ball, suggest me how to make like this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks