Auto Correct Formulas !?

  • Thread starter Thread starter cassy01
  • Start date Start date
C

cassy01

i have a Sheet with column A with all my short codes and Column B with
my Long Names in.

i want it so that on another sheet i type "R1" in a cell on column E it
replaces it with "Results234"

Is this possible. ?

i have a lot of different short names and long names on the sheet.

Many Thanks:D
Benn
 
Sure, just columns A and B in a lookup table, e.g.

=VLOOKUP(A2,Sheet1!$A$1:$B$100,2,0)

when you type R1 i cell A2 and let's say you put this formula in B2 it will
return
the adjacent cell to the right of the short name column
 
Benn
I don't think you can do an autocorrect in this way without programming. Some options

1) You could put all of your autocorrections into you Tools>Autocorrect file

2) Use data validation so you can select the actual long name from a list

3) write a macro to lookup the short name in your table and replace it with the long name. I'll play around with it and see if I can get something together. Meantime someone else may have already done this and could post the code

Good Luck
Mark Graesse
(e-mail address removed)

----- cassy01 > wrote: ----

i have a Sheet with column A with all my short codes and Column B wit
my Long Names in

i want it so that on another sheet i type "R1" in a cell on column E i
replaces it with "Results234

Is this possible.

i have a lot of different short names and long names on the sheet

Many Thanks:
Ben
 
Back
Top