Create Auto Text in Excel?

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

I want to be able to add the following function
(=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename
",A1),1))) into any excel sheet that I'm working on like you can do in Word
with Auto Text insert.

I think I should be able to do this with a macro but I can't figure out how
to do it.

Any help much appreciated.

Cheers

Lee
 
First, you can shorten the formula a bit and reduce the number of
function calls by using

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)

XL doesn't support autotext, but it does have autocorrect.

Make an autocorrect entry (Tools/Autocorrect), say "shname" and assign
it to your formula. Then, when you want to enter the formula, type in
shname instead.
 
Back
Top