Extract cell data before and including last number

are all of your examples 3 on the left, then a space then the next 5?
if so this will work for you... =MID(A2,5,5)
however I have a suspicion that your data is more varied.

Power Query Solution

Please Login or Register  to view this content.

Power Query is a free AddIn for Excel 2010 and 2013, and is built-in functionality from Excel 2016 onwards (where it is referred to as "Get & Transform Data").

It is a powerful yet simple way of getting, changing and using data from a broad variety of sources, creating steps which may be easily repeated and refreshed. I strongly recommend learning how to use Power Query - it's among the most powerful functionalities of Excel.

- Follow this link to learn how to install Power Query in Excel 2010 / 2013.

- Follow this link for an introduction to Power Query functionality.

- Follow this link for a video which demonstrates how to use Power Query code provided.

Is that the raw data or the solution. Not clear what it represents. Suggest you read the yellow banner at the top of this page.

Based on your latest

Please Login or Register  to view this content.

It does not work in Google Sheets. That is something you should have mentioned in your first post and you should have posted it in the Google Section of the forum. I will move this for you. Please note this for the future. Your profile indicates 365 and not Google sheets. Also confusing.

Hi Jacks,

Alan used Power Query but here is a VBA solution that gives a user defined function (UDF) to reverse a string.

Please Login or Register  to view this content.

And I also use the newer Excel 365 function of "Sequence" to list digits from 0 to 9 and "TextBefore".
The formula then looks like:

Formula:

Please Login or Register  to view this content.

The file is in the attached below.
VBA reverse to Trim After last Digit.xlsm

Hope this helps.

Hi Jacks,

Alan and I are Excel guys and I don't know if Google Sheets has all the features that MS Excel has. I really don't know if Sheets has "TextBefore", "Sequence" or a language like VBA behind it.

If sheets has a Reverse String function then you can do it in my method. If you reverse the text string and find the first digit and take the text before that digit. Then find the length of these extra characters.

Then use the entire length of the string minus the length found above in a Left() function to get your answer. I'm pretty sure Sheets has a basic Left() function. It might even have one that you could use if Right() looked from the rear??