KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have this code: strInfo = "3101234567 Ryan Maybach" Dim varSplit As Variant varSplit = Split(strInfo, " ") strPhoneNumber = varSplit(0) strOwner = varSplit(1) So, strPhoneNumber = "3101234567" and strOwner = "Ryan" I want to make it so that strOwner = "Ryan Maybach", the full name, and not just the first name. How do I split the strInfo string at the first instance of a space " "?
Tags (comma-separated)
Save Edits
Cancel