Breaking News: Grepper is joining You.com. Read the official announcement!

excel vba split string into cells

Add Answer

Ana Faria Carneiro answered on April 26, 2022 Popularity 8/10 Helpfulness 4/10

answer excel vba split string into cells

related excel vba split string into cells

related excel vba split string into array

excel vba split string into cells

Comment

Sub SplitBySemicolonExample()
    'Define variables
    Dim MyArray() As String, MyString As String, I As Variant, N As Integer
    
    'Sample string with semi colon delimiters
    MyString = "john@myco.com;jane@myco.com;bill@myco.com;james@myco.com"
    
    'Use Split function to divide up the component parts of the string
    MyArray = Split(MyString, ";")
    
    'Clear the worksheet
    ActiveSheet.UsedRange.Clear
    
    'iterate through the array
    For N = 0 To UBound(MyArray)
        'Place each email address into the first column of the worksheet
        Range("A" & N + 1).Value = MyArray(N)
    Next N
End Sub

Popularity 8/10 Helpfulness 4/10 Language vb

Source: www.automateexcel.com

Tags: cells excel string vba

Link to this answer
Share Copy Link

Contributed on Apr 26 2022

Ana Faria Carneiro

0 Answers Avg Quality 2/10

Closely Related Answers

excel vba split string into cells

Comment

Sub SplitBySemicolonExample()
    'Define variables
    Dim MyArray() As String, MyString As String, I As Variant, N As Integer
    
    'Sample string with semi colon delimiters
    MyString = "john@myco.com;jane@myco.com;bill@myco.com;james@myco.com"
    
    'Use Split function to divide up the component parts of the string
    MyArray = Split(MyString, ";")
    
    'Clear the worksheet
    ActiveSheet.UsedRange.Clear
    
    'iterate through the array
    For N = 0 To UBound(MyArray)
        'Place each email address into the first column of the worksheet
        Range("A" & N + 1).Value = MyArray(N)
    Next N
End Sub

Popularity 8/10 Helpfulness 4/10 Language vb

Source: www.automateexcel.com

Tags: vba string cells excel

Link to this answer
Share Copy Link

Contributed on Apr 26 2022

Ana Faria Carneiro

0 Answers Avg Quality 2/10

excel vba split string into array

Comment

Dim inputString As String
inputString = "Hello,World,How,Are,You"
Dim arr() As String
arr = Split(inputString, ",")

Popularity 5/10 Helpfulness 3/10 Language vb

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

excel vba split string into cells

Contents

More Related Answers

excel vba split string into cells

Closely Related Answers

excel vba split string into cells

excel vba split string into array

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.