Parse Strings

[MadeCurler]

How do I split "Hello World" into two distinct objects:
String 1 = "Hello World" (I then want)
String 2 = "Hello"
String 3 = "World"

Do I use the Split function?

Regards

 

[boblarson]

Yes, you can use the split function:

Dim varSplit As Variant

varSplit = Split(String1, " ")

Then you can get the values by

String2 = varSplit(0)
String3 = varSplit(1)

 

[MadeCurler]

Bob - Thanks very much....sorry I posted the question in the wrong place...I'm still getting used to the site....Regards....Bill

 

[boblarson]

Glad we could help!