Searching for Inventory Number in a String

Could anyone tell me how to make a formula that will pull out my inventory number from a string? The inventory numbers can be anywhere from 3 characters to 8. Please note that only in this example are the preceding "G" is present. Sometimes the inventory number is at the end of the string. TIA!

G BM1240 Bookmark $9.00
G MB16 Men's Bracelet $23
G CC1225 Car Charm $12
G FRB1323 Full Rosary Bracelet $35
G E1330 Earrings $8
G B2174 Bracelet $13
G AR9 Anglican Rosary $17
G SC2030 Stethoscope Charm $10
G R1452 Rosary $31
G ODR1428 One Decade Rosary $11
G CC1248 Car Charm $13.00
G PR1444 Pocket Rosary $11
G RB1545 Rosary Bracelet $14

title updated

You should post a better sample showing the various cases
(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to Quick Post button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

Originally Posted by roxdrob01

Why do I get the feeling I'm being nit-picked to death. I'll be happy to leave this forum. This ProtonLeah has made me feel very unwelcomed with all of her "rules". I've never been to a forum run by a Nazi before. Good day and sorry I bothered you.

ProtonLeah has reason to ask you to change the title like "Searching" . Now the title is OK, but ask you to post more records in order to deeply understanding your data.
Anyway, what is your data rule:
Does the Inventory Number : 1 to 3 uppercase letters and following by 1 to 4 digits?

Such a long formula, but it should solves your issue:
With A1 contains string:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Try this
Enter in B1 and copy down

Formula:

Please Login or Register  to view this content.

v	A	B
1	G BM1240 Bookmark $9.00	BM1240
2	G MB16 Men's Bracelet $23	MB16
3	G CC1225 Car Charm $12	CC1225
4	G FRB1323 Full Rosary Bracelet $35	FRB1323
5	G E1330 Earrings $8	E1330
6	G B2174 Bracelet $13	B2174
7	G AR9 Anglican Rosary $17	AR9
8	G SC2030 Stethoscope Charm $10	SC2030
9	G R1452 Rosary $31	R1452
10	G ODR1428 One Decade Rosary $11	ODR1428
11	G CC1248 Car Charm $13.00	CC1248
12	G PR1444 Pocket Rosary $11	PR1444
13	G RB1545 Rosary Bracelet $14	RB1545