I don't know if you are still reading this, but there is a button in the
Standard Toolbar called "Paste Function". Select a blank cell and click it.
This bring up a function wizard with categories on the left and functions on
the right. If you select a function you can ask the paperclip about it by
pressing the question mark in the bottom left of the paste function window.
I don't think any function in the Add-ins toolpak is included, and DATEDIF is
not included. I think most if not all of the other functions are listed.

Anyways, there is a category called text which show all of the text functions.

"Jonah" wrote:

Another great solution.

P.S. How do I start to lookup a formula event when I do not have the event name
to look up. If I knew it was RIGHT I would not necessarily need the help of a
newsgroup. I was using LEFT(K2, LEN(K2)-3) to reduce the length of the string by
changing the value 3, to 2 and so on. Not a very neat solution I must add.

J
==========
Sloth wrote:

"I need the initial letter from a name and the last letter" - use this formula
=LEFT(A1,1)&RIGHT(A1,1) Example: "John Smith" will return "Jh"