Pull one word if 1 and two words if 2

In your sample, do all descriptions have "Handbag" in the title and is it always going to be a 1 or a 2?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).

Maybe this

Enter formula in B1 and copy down

Formula:

Please Login or Register  to view this content.

v	A	B	C
1	CHEETAH HANDBAG Brown	1	CHEETAH
2	CHENHAO HANDBAG Blue	1	CHENHAO
3	CHERRY BLOSSOM HANDBAG Black	2	CHERRY BLOSSOM
4	CHERRY BLOSSOM HANDBAG Blue	2	CHERRY BLOSSOM
5	CHERRY BLOSSOM HANDBAG Yello	2	CHERRY BLOSSOM

Here's another one...

Data Range

	A	B	C
1	CHEETAH HANDBAG Brown	1	CHEETAH
2	CHENHAO HANDBAG Blue	1	CHENHAO
3	CHERRY BLOSSOM HANDBAG Black	2	CHERRY BLOSSOM
4	CHERRY BLOSSOM HANDBAG Blue	2	CHERRY BLOSSOM
5	CHERRY BLOSSOM HANDBAG Yellow	2	CHERRY BLOSSOM
6	CHERRY BLOSSOM HANDBAG Yellow	3	CHERRY BLOSSOM HANDBAG
7		------

This formula entered in C1 and copied down:

=IFERROR(LEFT(A1,FIND("|",SUBSTITUTE(A1," ","|",B1))-1),"")