Extracting numbers from at end of a string - MrExcel
Jul 4, 2022 · Hello, I am trying to find a formula that will extract the numbers at the end of a string. Sometimes the numbers will be 1, 2, 3, 4 or more. I tried using this ...
Extract 8 digit number from a string | MrExcel Message Board
Oct 30, 2015 · Sep 10, 2024 Fluff L Extract 5 digit.5digit number from text string LKB2025 Sep 16, 2025 Excel Questions 2 3 Replies 20 Views 5K Sep 16, 2025
Find and return 10-digit number from string - MrExcel
Jul 25, 2011 · Hey all, I am working with data where I need to extract a 10-digit number from a string. Where the 10-digit number is in the string varies, so I can't use a simple left/len …
Extracting currency amounts from a string of numbers and text
Nov 16, 2018 · C1 and F1 formula converts results to Real Numbers, format cell as currency if desired. D1 and G1 formula Only extracts the currency value from the original Text String, and …
Formula to return text only from left of string until first number is ...
May 13, 2013 · I needed to extract the text, which I was able to do using the above. If I want to get everything to the right of said text (in my case it is all numbers), what formula would work?
Extract text between second and first space from the right in text …
Dec 1, 2023 · Sheet1 Hello, I need to extract the reference number from the text strings above, I have many rows of data that my formula needs to work on, but these two should serve as …
Extract 5 digit number from string | MrExcel Message Board
Mar 12, 2006 · Hello, I need to extract a set of 5 numbers from a string of characters. The number set I need is always 5 digits long, always starts with a 1, and always begins after a period. But …
Extract second to last number from string - MrExcel
May 1, 2018 · Hello, what formula could I use to extract the second to last and third to last numbers from the below string separately? I want to pull 4.410 out and then the 5.007 out. …
How to extract the right most numbers from a text string?
Mar 17, 2015 · Hello, I need to extract numbers from a text string. The numbers appear to the right of the string. There are actually two numbers there. One is the count and the other is the …
Extracting a number with decimal and percentage from a text string
Feb 26, 2015 · Hi, Could anyone please assist with a formula. I am trying to extract a number with decimal and percentage sign from a stringed text. As example it would read. Cell: B243 We …