Change order of Text

[fgmoon353]

I the first one is an example of how I need it too look. Can someone help me with a formula?

Beebops Tumbler 12oz 360pc Pallet	Beebops Tumbler 12oz Pallet 360pc
Insect handled Jar 10oz 1320pc Pallet
Water Bottle 14oz 756pc Pallet
CHEM Pro Bottle 14oz 648pc Pallet
Laundry Pro 14oz Bottle 1050pc Pallet

 

[Fluff]

What eversion of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[fgmoon353]

What eversion of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Done, 365

 

[Fluff]

Thanks for that.
How about

Fluff.xlsm
	A	B
1
2	Beebops Tumbler 12oz 360pc Pallet	Beebops Tumbler 12oz Pallet 360pc
3	Insect handled Jar 10oz 1320pc Pallet	Insect handled Jar 10oz Pallet 1320pc
4	Water Bottle 14oz 756pc Pallet	Water Bottle 14oz Pallet 756pc
5	CHEM Pro Bottle 14oz 648pc Pallet	CHEM Pro Bottle 14oz Pallet 648pc
6	Laundry Pro 14oz Bottle 1050pc Pallet	Laundry Pro 14oz Bottle Pallet 1050pc
Sheet7

Cell Formulas
Range	Formula
B2:B6	B2	=TEXTJOIN(" ",,TEXTBEFORE(A2," ",-2),CHOOSECOLS(TEXTSPLIT(A2," "),-1,-2))

 

[fgmoon353]

Thanks for that.
How about

Fluff.xlsm
	A	B
1
2	Beebops Tumbler 12oz 360pc Pallet	Beebops Tumbler 12oz Pallet 360pc
3	Insect handled Jar 10oz 1320pc Pallet	Insect handled Jar 10oz Pallet 1320pc
4	Water Bottle 14oz 756pc Pallet	Water Bottle 14oz Pallet 756pc
5	CHEM Pro Bottle 14oz 648pc Pallet	CHEM Pro Bottle 14oz Pallet 648pc
6	Laundry Pro 14oz Bottle 1050pc Pallet	Laundry Pro 14oz Bottle Pallet 1050pc
Sheet7

Cell Formulas
Range	Formula
B2:B6	B2	=TEXTJOIN(" ",,TEXTBEFORE(A2," ",-2),CHOOSECOLS(TEXTSPLIT(A2," "),-1,-2))

Thank you so much!

FOLLOW UP QUESTION: Sometimes I get a field like below, how would i modify that formula to give "Pallet Pro 1050pc"

Laundry Pro 14oz Bottle 1050pc Pallet Pro

 

[Fluff]

Do you have any more variations?

 

[fgmoon353]

Do you have any more variations?

So far I think that's it... Thanks for your help

 

[Fluff]

Ok, how about

=LET(a,TEXTSPLIT(A2," "),TEXTJOIN(" ",,FILTER(a,ISERR(FIND("pc",a))),FILTER(a,ISNUMBER(FIND("pc",a)))))