Excel VBA extract words from string

Question

I have a string in this format:

>word1>longword2>longerword3>word4>anotherword5>

In VBA I am looking to extract all words between the characters >. Any guidelines will be much appreciated - words contain numbers and special characters and are not fixed in length.

bobby4078 · Accepted Answer · 2014-05-16 13:52:37Z

2

Use the split function : http://msdn.microsoft.com/library/6x627e5f(v=vs.90).aspx

There is an example at the end of the link.

You need to use something like:

Dim TestArray() As String;
TestArray = Split(myString, ">")

edited May 16, 2014 at 13:52

answered May 16, 2014 at 13:25

bobby4078

1031 silver badge7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

stenci Over a year ago

This is VB, not VBA (which doesn't allow the assignment in the declaration)

eventHandler · Accepted Answer · 2014-05-16 13:38:10Z

1

this code will solve your problem

Dim longString as String
longString = "word1>longword2>longerword3>word4>anotherword5>"

Dim arrayString() as String
arrayString = Split(longString, ">")

answered May 16, 2014 at 13:38

eventHandler

1,21113 silver badges24 bronze badges

Collectives™ on Stack Overflow

Excel VBA extract words from string

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related