L
L
lord amotar2019-11-07 07:53:42
Macros
lord amotar, 2019-11-07 07:53:42

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?
5dc3a323826e6319613249.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
V
Vadim, 2019-11-07
@webaikos

https://support.office.com/ru-ru/article/%D0%A0%D0...
The separator is a space.

B
BasiC2k, 2019-11-07
@BasiC2k

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 question

Ask a Question

731 491 924 answers to any question