split problem
 

Hi all,

I am interesting to break a string with spaces into an array with substrings
and to have it in the same cell.
for example:
dim MyString as string
MyString = range("A1").value ' range("A1").value = "Good morning"
range("A1").value = split(MyString, " ").

The problem is that instead of:
Good
morning

as range("A1").value I get only: morning.

Please help me to fix it!

Thanks

Eli

split problem
 

'Once you split it returns an array; so that you could try

Dim MyString As String
MyString = Range("A1").Value
Range("A1:B1") = Split(MyString, " ")

'Instead ..if you mean to replace a splace with carriage return then try
Range("A1") = Replace(Range("A1"), " ", vbLf)


--
Jacob


"אלי" wrote:

Hi all,

I am interesting to break a string with spaces into an array with substrings
and to have it in the same cell.
for example:
dim MyString as string
MyString = range("A1").value ' range("A1").value = "Good morning"
range("A1").value = split(MyString, " ").

The problem is that instead of:
Good
morning

as range("A1").value I get only: morning.

Please help me to fix it!

Thanks

Eli

split problem
 

Many thanks!

"Jacob Skaria" wrote:

'Once you split it returns an array; so that you could try

Dim MyString As String
MyString = Range("A1").Value
Range("A1:B1") = Split(MyString, " ")

'Instead ..if you mean to replace a splace with carriage return then try
Range("A1") = Replace(Range("A1"), " ", vbLf)


--
Jacob


"אלי" wrote:

Hi all,

I am interesting to break a string with spaces into an array with substrings
and to have it in the same cell.
for example:
dim MyString as string
MyString = range("A1").value ' range("A1").value = "Good morning"
range("A1").value = split(MyString, " ").

The problem is that instead of:
Good
morning

as range("A1").value I get only: morning.

Please help me to fix it!

Thanks

Eli