Function 01)

01) Add Function AddQuotesatComma

Using the function

=AddQuotesatComma(YourString)

You can quickly add single quotes to the string everywhere a comma is encountered. This allows a user to enter alphanumeric criteria separated with just a comma.

This formula:       =ADDQUOTESATCOMMA(“AAA,BBBB,CCC,DDDDD”)
Would return:        ‘AAA’,’BBBB’,’CCC’,’DDDDD’

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc


More Information

During the last 23 years we have created over 300 solutions for end users (we've stopped counting).