Changing a word/number to another cell, from a filtered word

Hello, what i want to do is to move a bunch of characters in front of a known word that i prefiltered, in example in the cell A1, there's the following text: "Serial Number 1A3B4", and in the cell A2 there is this one: "Serial Number 5C7D8", the question is, is there a way that i can move all the characters, but only the characteres to another column at once, in example, in the cell B1 now would have the characters "1A3B4" and the cell B2 would have "5C7D8", is there a way to move it in massive amounts? like 3000 cells at once? thanks for all the help.