Favorite Function option?

[rukiddin]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I use the following function all the time.

=SUBSTITUTE(IF(RIGHT(TRIM(A1))="-",RIGHT(TRIM(A1))&A1,A1),"-","",2)+0

Is there a way I can map this function to a shortcut key, or make it easy to retrieve when I need it? Right now I have it store in a text file, which I leave open so I can copy and paste it when I need it. There has got to be a better way.

Thanks

Mike

 

[CyberTaz]

One simple option: Copy the formula & add it to the Scrapbook. Name it as
you wish & when you need it just drag it into the cell.

Another option: Create an AutoCorrect entry with a "trigger" such as
subfx... Any time you type the trigger into a cell & press return the
trigger text will be replaced with the expression.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[rukiddin]

The AutoCorrect with a "trigger" sounds interesting, would that also potentially update the field variables in the formula and save me from having to update them each time? I'll check out the scrapbook option for right now though.

 

[rukiddin]

After playing with the Autocorrect and the scrapbook options, I have a better idea of how they work. Both represent decent solutions. Thank you very much.

 

[CyberTaz]

You're certainly welcome -- I'm glad you found them useful. As you've no
doubt found by now, both methods insert exactly what you have stored so you
do have to update the cell references yourself... But that's not much more
inconvenient than typing the references into any newly inserted function.

AFAIK the only way to have the variables update automatically is to
copy/paste the formula from one cell to another.

Regards |:>)
Bob Jones
[MVP] Office:Mac