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.
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.