Function 01)
Add Function ADDQUOTESATCOMMA to active workbook
=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