Limiting the SPLIT function...

[Aitch]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]ABC - DEF - GHI - JKL - MNO[/TD]
[TD]ABC[/TD]
[TD]DEF[/TD]
[TD]GHI[/TD]
[TD]JKL[/TD]
[TD]MNO[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]ABC - DEF - GHI - JKL - MNO[/TD]
[TD]ABC[/TD]
[TD]DEF[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Using SPLIT with a "-" delimiter gives the first output above - is there a way to limit the command so it splits ONLY the first two parts?

Thanks for your help!

 

[James006]

Hello,

What about only using 0 and 1 ... ???

 

[veyselemre]

Sub test()
    Range("B1").Resize(, 2).Value = Split(Range("A1").Value, "-", 3)
End Sub