Split function by comma and hyphen simultaneously

		Microsoft Office Forums > Microsoft Word > Word VBA
Split function by comma and hyphen simultaneously

08-15-2021, 05:30 AM

laith93

Windows 10 Split function by comma and hyphen simultaneously

Office 2019

Competent Performer

Join Date: Jul 2021

Posts: 117

Quote:

Originally Posted by Guessed

Try this version

Fantastic,
Thank you so much, Mr. Andrew, the code works fine.

Just I want to increase my info in VBA, why we used this line again

Code:

 nSplitItem = Split(strPage, ",")

Also, the delimiter of split function is "," not ", & -" after editing the code
Can you explain as you can, otherwise ignore it.

Thank you again

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Mistake in the help file for String "Split Function"?	John 4	Word VBA	6	11-19-2020 06:02 AM
Hyphen until the end of the row	abc3132	Word	13	10-31-2019 04:36 AM
Split function in Excel (split the screen)	Officer_Bierschnitt	Excel	1	07-05-2017 07:02 AM
Split function not working as I expect??!!	XmisterIS	Word VBA	9	04-08-2014 04:41 PM
Cross-reference function to update bullet header and number simultaneously	dljenks	Word	1	01-03-2014 01:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:04 PM.