mrmmickle1
Well-known Member
- Joined
- May 11, 2012
- Messages
- 2,461
If I have strings that look like this that I'm trying to fit into a paragraph of text via code:
String 1 = "Methylphenidate, Nordiazepam-Diazepam, Fentanyl"
String 2 = "Methylphenidate, Nordiazepam-Diazepam, Fentanyl, THC"
String 3 = "Methylphenidate, Nordiazepam-Diazepam, Fentanyl, MDMA, THC"
How Can I alter them via VBA code to look like this so they will look proper in a sentence:
String 1 = "Methylphenidate, Nordiazepam-Diazepam and Fentanyl"
String 2 = "Methylphenidate, Nordiazepam-Diazepam, Fentanyl and THC"
String 3 = "Methylphenidate, Nordiazepam-Diazepam, Fentanyl, MDMA and THC"
Any help would be much appreciated.... My brain doesn't seem to be functioning properly today.
String 1 = "Methylphenidate, Nordiazepam-Diazepam, Fentanyl"
String 2 = "Methylphenidate, Nordiazepam-Diazepam, Fentanyl, THC"
String 3 = "Methylphenidate, Nordiazepam-Diazepam, Fentanyl, MDMA, THC"
How Can I alter them via VBA code to look like this so they will look proper in a sentence:
String 1 = "Methylphenidate, Nordiazepam-Diazepam and Fentanyl"
String 2 = "Methylphenidate, Nordiazepam-Diazepam, Fentanyl and THC"
String 3 = "Methylphenidate, Nordiazepam-Diazepam, Fentanyl, MDMA and THC"
Any help would be much appreciated.... My brain doesn't seem to be functioning properly today.