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

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

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,113,824
Messages
5,544,539
Members
410,619
Latest member
gregor222
Top