If (the first 3 letters of a variable's value) = (the first 3 letters in a given cell)

I'm using the s.autECLPS.GetText command to grab text out of the Terminal program.

Once I grab data from that, I put it into a variable. I want to check that variable against A1, A2, A3, A4, etc., to see if that value already exists in the sheet I have.

My problem comes from the fact that the text that I grab can vary in lengths - sometimes it's 5 digits, sometimes it's 20, so I've had to build the s.autECLPS.GetText to grab the max length each time - so on SHORTER items, the end result may include 5 digits, and 15 blank spaces, like this:

Example 1: ASDF1234_________________
Example 2: ASDFJSODAFJ2394827349293JS

Prior to this function running, I have another piece of code that runs "text to columns" on column A and delete multiple blanks, so all of my data in column A has NO additional spaces at the end.

This was working fine until I tried to do this last part. I cannot compare the data taken into the variable via s.autECLPS.GetText with the data in a cell, because the additional spaces make them always not equal.

Please Login or Register  to view this content.

The cell I am comparing it to is held in:

Please Login or Register  to view this content.

How do I say:

Please Login or Register  to view this content.

Thanks!

Not sure I totally follow you. Would this work:

Please Login or Register  to view this content.

Hmmm - this does not work.

I will try to explain a bit better what i want to do here:

A2 = D12345

When I type in dCheck = s.autECLPS.GetText(1, 8, 3) , it loads the Terminal, then goes to Row 1, Cell 8, and grabs the first 3 letters after that. The text that it grabs is "D12"

I then want to go back into Excel and ask "Is the value of dCheck equal to the first 3 letters in cell A2?"

Excel should then look and say "Yes, D12 = D12"

When I used your code, (and added msg boxes to see what was was being captured), I found that:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Is just giving me null value, instead of the first 3 characters from the left.

I'd try to help fix the code, but I'm not familiar with the Application.Trim command at all

The trim function trims all the blank spaces. You could also use the built-in clean function if that would be an issue.

Would something like this work?

Please Login or Register  to view this content.

I messed around with the code, so I can't go back and paste that in - but I did test out doing:

Please Login or Register  to view this content.

and it trimmed all the extra spaces out of the variable dCheck - this is EXACTLY what I needed. thank you so much!