Extracting TEXT

Bennets04

Board Regular
Joined
Jul 30, 2010
Messages
58
Morning all,

If I had a row of devices in A:A.
iPhone 8 256GB
iPhone 8 64GB
iPhone 8 64GB + AirPods
iPhone 8 64GB + Beats Solo3
iPhone 8 Plus 256GB
iPhone 8 Plus 64GB
iPhone 8 Plus 64GB + AirPods
iPhone 8 Plus 64GB + Beats Solo3

What would be the best formula to just extract the text before the space after the GB on the end? So it would return this in column B:B:
iPhone 8 256GB
iPhone 8 64GB
iPhone 8 64GB
iPhone 8 64GB
iPhone 8 Plus 256GB
iPhone 8 Plus 64GB
iPhone 8 Plus 64GB
iPhone 8 Plus 64GB

Many thanks
Steve
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Bennets04

Board Regular
Joined
Jul 30, 2010
Messages
58
Thank you that worked perfectly... Will save that formula down as very handy!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,501
Messages
5,529,234
Members
409,857
Latest member
KailuaTown
Top