> ## Content Index
> Fetch the complete content index at: https://nolongerset.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Archive Collection: String Functions
- URL: https://nolongerset.com/archive-string-functions/
- Published: 2024-01-04T18:54:00.000Z
- Updated: 2026-05-08T12:37:53.000Z
- Description: I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: String Functions.
- Author: Mike Wolfe
- Tags: Archive, #Import 2026-05-20 02:59

*I've been writing a daily article here since September 1, 2020; that's over 1,200 articles. I haven't missed a day yet, and that includes [Christmas and Easter](https://nolongerset.com/tag/holiday/). I'm currently on a family vacation, which makes maintaining this streak a bit...tricky.*

*I'm writing this in the *present* tense, but I'm writing it for *future* publication with links to *past* articles. Let's hope the time-space continuum holds up.*

*In any case, as the slacker Firstie says to the Stony Lonesome Gate guard twenty minutes before Taps, let me get to the Point. I've got a daily publishing streak to keep up. But I don't want to be writing and publishing articles on vacation. And I still want to provide you with something of value to read each day. So I settled on creating a series of curated article lists that I think you'll find beneficial.*

*I'm hoping at least some of these articles are ones you haven't read before. And if you're so obsessed with me that you *have* read all my articles, I'm hoping that they'll keep you busy enough that you don't come looking for me and my family 😳.* 

*Enjoy!*

---

## String Functions

[The Pluralize FunctionYou don’t have to settle for messages like, “1 record(s) inserted.” This simple function is an easy way to format strings for pluralization in VBA.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/04/macchiato-2033553_1920.jpg)](https://nolongerset.com/the-pluralize-function/)

[How to Remove Special Characters from a VBA StringA simple function to remove special characters from a string in VBA. Useful for sanitizing file names, sheet names in Excel, and lots of other stuff.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/12/food-1554036_1920.jpg)](https://nolongerset.com/stripspecchars/)

[Come TogetherDo you build strings in loops? Stop trimming the delimiter at the end of the loop. There’s a better way.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/09/chain-3481377_1920.jpg)](https://nolongerset.com/come-together/)

[Part and Parse()-lTake the Tag property and OpenArgs argument to the next level. This function makes it easy to assign and extract multiple values from a single string.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/construction-3734380_1920.jpg)](https://nolongerset.com/part-and-parse-l/)

[Quoth thy SQL? Evermore!Solving the “O’Malley problem” with dedicated functions to sanitize our strings. Little Bobby Tables would be proud.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/09/crow-3347677_1920-1.jpg)](https://nolongerset.com/quoth-thy-sql-evermore/)

[Dt() Function v3: Refactoring with Automated TestsReader Brenda Bachtold provides a more readable version of my date-wrapping function. Automated doc tests prove that her version functions the same as mine.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/12/Refactoring-with-Confidence.jpeg)](https://nolongerset.com/dt-function-v3/)

[Now you have two problemsSome people, when confronted with a problem, think “I know, I’ll use regular expressions.” Now they have two problems. --Jamie Zawinski![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/hammer-1629587_1920.jpg)](https://nolongerset.com/now-you-have-two-problems/)

[CreateGuid: A Reliable Way to Generate GUIDs in VBAA well-tested method to generate GUIDs in both 32-bit and 64-bit VBA.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/08/earth-3537401_1920.jpg)](https://nolongerset.com/createguid/)

[Converting Numbers to TextNeed to print business checks directly from Microsoft Access? You’ll need a way to convert numbers into text. The NumToString function does just that.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/american-1239040_1920.jpg)](https://nolongerset.com/converting-numbers-to-text/)

### Additional Reading

[Code LibraryBuilding Your LibraryThirteen years ago, I chose to maintain a folder of textfiles rather than a single Access database library. I’ve never once regrettedthat decision.No Longer SetMike Wolfe \[https://nolongerset.com/building-your-library/\]TheDependency TrainLet’s torture a train metaphor to illu…![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/09/prague-980732_1920.jpg)](https://nolongerset.com/code-library/#hash-stringfunctions)