Hi,

I have thousands of lines in a column, I need to find a text and move
it another column.

My data :

Col A

xxxx ABC1234 XXXX
xxxx ABC 1234 XXXx
xxxx ABC-1234 XXXx
xxxx ABC 1234a XXXx
xxxx ABC 1234ab XXXx
xxxx ABC-1234ab XXXx

What I need to find is the number and the last 1 or 2 character behind
it, such as 1234, 1234a or 1234ab and move it to column B.
ABC is fixed, but sometimes users put the space or "-" behind the ABC
and sometimes they use lower case.

I need the macro or the formula to figure it out, if possible.

Million of thanks.