Help, need to find and grab a value within a cell

[fullerorb7]

so in column "a" there is a number within a string of text and the text is never the same.
before the two digit number i am trying to find and use, there is a bracket and string of text which is the only constant value to reference from. example "[AA 11"

i have well over 1000 rows and the bracket and AA are always constant. i need to save this as a integer variable.

[Arkadi]

Can you provide a sample workbook?
It sounds like the number always starts at the 5th character, and goes until the end of the string?

[fullerorb7]

i dont have the workbook on my computer sadly.
picture a random set of words or a string of text that could be sentence length, anywhere from 4 characters to 20 characters(my guess) within the cell.
"[AA xx" where xx is two random numbers and a random string of text after too.

basically, if a code like this could be made, a find command for "[AA", skip a character and grab the next two values and save as an integer.

Sorry if i make this complicated.

[Arkadi]

Hi,

here is a start...

Please Login or Register  to view this content.

[fullerorb7]

ill definitely save this, but the number im trying to save is not in a static position, so this wont work.
but a start this is indeed, thanks.

[Arkadi]

I am not sure i understand.... You said it starts with bracket AA space then number.... Now you say not a static position? If you could give some actual data that represents what we are dealing with I can help, otherwise Im lost

[Arkadi]

Is the idea here that there is always a space before the number you want to extract? And if so, is it the first/only space?

[fullerorb7]

CNT XJDFJTS01-1938 ben [AA 24-AJAX-424
METRO DHEYUDIX [AA 12]

example, every row is different, but the "[AA" with a space right after is a constant reference.

[Arkadi]

Ok, is it always AA? Or do those letters change?

And first example has a dash and letters again after 24.... You only want the 24 in that example?

[fullerorb7]

Ok, is it always AA? Or do those letters change?

And first example has a dash and letters again after 24.... You only want the 24 in that example?

It is always AA and the numbers after are always different, but will remain 2 characters.

[bakerman2]

Please Login or Register  to view this content.

Now the question remains of what you want to do with the number found.