Function 01)

Add Function ADDQUOTESATCOMMA to active workbook

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