Extracting TEXT

[Bennets04]

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

 

[Rick Rothstein]

Give this formula a try...

=LEFT(A1,FIND("GB",A1)+1)

 

[Bennets04]

Thank you that worked perfectly... Will save that formula down as very handy!