VBA version of left, mid, and right

[KGH]

Is there a method using VBA to duplicate the Excel functions of left, mid, and right?

I have variable length strings that have a '/' in them such as "0.5/9".

I need to break them into two variables before and after the '/'.

How can this be done using VBA?

[stanleydgromjr]

KGH,

Welcome to the Excel Forum.

Try using Split

See:
http://www.excelforum.com/excel-prog...iple-rows.html


Post your workbook (or sample) - scroll down and see "Manage Attachments".


See the attached workbook "Split Text - KGH - SDG.xls" with macro "SplitText".

Then run the "SplitText" macro.

[mikerickson]

Stanley's use of Split would be the way to approach this problem, but you should also be aware that VBA has the string functions Left, Right and Mid.