• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 143
  • Last Modified:

How do i separate these words

Im trying to separate this message into 3 parts. they have a space between them, for example:

message= Hi, I'm Andrew.

how do i separate this to:
text1=Hi,
Text2=I'm
text3=Andrew.
0
andyakira
Asked:
andyakira
1 Solution
 
Farzad AkbarnejadCommented:
Hi,
    Dim message As String
   
    Dim text1 As String
    Dim text2 As String
    Dim text3 As String
   
    Dim arrText() As String
   
   
    message = "Hi, I'm Andrew."
    arrText = Split(message, " ")
   
    text1 = arrText(0)
    text2 = arrText(1)
    text3 = arrText(2)
   
    MsgBox text1 & vbCrLf & text2 & vbCrLf & text3


-FA
0
 
andyakiraAuthor Commented:
tyvm
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now