I have some strings such as "28,456.0324 ADA-9F4", which contain all start with a number followed by some characters and maybe additional numbers. I would like to extract the first number, and also extract the first three letters which follow the first number. So in the string mentioned above the outpuit of the two formulas would be "28'456.0324" and "ADA".
I already searched around, and found an extremely long formula to extract a number, but that didn't work as it was designed to turn all numbers in the string into one big number, and effectively ignored the decimal point.
An example spreadsheet is attached with the desired outcome shown in yellow.
Bookmarks