Answer the question
In order to leave comments, you need to log in
How to split a string by words?
for example
, in the line there is a suggestion how to transfer separately according to the words as in the picture?
Answer the question
In order to leave comments, you need to log in
https://support.office.com/ru-ru/article/%D0%A0%D0...
The separator is a space.
The separator in this case is a space.
Two operations are required:
1. Convert the string to an array.
2. Insert an array into a sheet.
I'm writing without an IDE, if you need to correct it:
Dim sSource As String
Dim oArr As Variant
oArr = Split(sSource, " ")
Range(Cells(1, 1), Cells(1, Ubound(oArr)).Value = oArr
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question