I work with alot of names, ID numbers, and text in Excel. Three TEXT
functions I would find handy would be:

NameFirst(cell,format)
NameLast(cell,format,criteria)
Instance(text,criteria)

The first two would automatically find the first or last name from a cell
containing a name such as Robert H. Smith-Johnson. The format option should
allow you to put in a number and get the name returned formatted in
lowercase, uppercase, or first letter capitol. NameLast criteria should allow
for returning the full last name with or without hyphen, only the first or
only the last part of a hyphenated name.

The last function would allow users to search for the number of instances of
a certain character in a cell.

I am sure that others would also find these functions useful instead of
writing up long abstract formulas and macros to do what should be a simple
tasks.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions