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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

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,114,506
Messages
5,548,465
Members
410,838
Latest member
naydeenmonzon
Top