Limiting the SPLIT function...

[Aitch]

ABC - DEF - GHI - JKL - MNO	ABC	DEF	GHI	JKL	MNO
ABC - DEF - GHI - JKL - MNO	ABC	DEF

<tbody>
</tbody>

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