how to get substring in VBA excel?

[forum_admin]

how to get substring in VBA excel? I want to get specific string or substring from the cell value. Is there any way to get specific character or substring using VBA code?

[Guest]

You can user LEFT and RIGHT function for string Manipulation.

For Example:

Range("A1").value="How Are You?"
LEFT function to get only "How":
LEFT(A1,3)

So it will take 3 character form left part of the string.

RIGHT function to get only "Are You?":
RIGHT(A1,8)

So it will take 8 character form right part of the string.