Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Split and sort problem | Excel Programming | |||
Data Split and graph problem | Excel Programming | |||
Split cell info via VB problem | Excel Programming | |||
Formula Split or parenthesis problem? | Excel Discussion (Misc queries) | |||
Excel split window refresh problem | Excel Programming |