Returning first 3 characters of a string

[Drewbie57]

I would like to get the first three characters of a string...

What I have is a bunch of part numbers starting with ST- and I am using them in a macro. There are are parts in there though and the spacing between them is inconsistant. I just have a for loop going down the spread sheet so all I need is a way to get the first three characters of a string for my If statement. Thanks.

 

[Andrew Poulsom]

=LEFT(A1,3)

wher A1 contains your string

 

[Drewbie57]

=LEFT(A1,3)

wher A1 contains your string

I believe that is what you would have done to display that in the spreadsheet itself.... and I don't have room for it. I would like the macro to read the string as it is from the Sheet and then take its first three characters

 

[Andrew Poulsom]

In code:

x = Left(Range("A1").Value,3)

VBA has the same function.