How do you split a string in vba?

if you want to extract or split off part of a string then you use the Left, Right and Mid functions.