'extract data immediately after numeric value in a cell in google sheets

I have cells containing data in google spreadsheet as quantity of some entity and I wish to extract only that string which is after the quantity value (number).

Example, If my data is :

learn 10 functions
Watch 3 YT tutorial videos
complete 10 charts

I want the result as :

functions
YT tutorial videos
charts
regexgoogle-sheetsextractspreadsheet


Solution 1:[1]

try:

=INDEX(IFNA(REGEXEXTRACT(A1:A, "\d+ (.+)")))

enter image description here

Solution 2:[2]

I don't know what language you're looking for but this code is in js.

// cellData is the data that you mentioned

let result = cellData.split(/(\d)/);
console.log(result.pop().trim());

Solution 3:[3]

Assuming that you don't have multiple numbers occurrences in the text, you can use this regex.

(?<=\d\s).+$

This regex will match all characters after a number followed by a single space to the end of the line.

Regex Demo

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 player0
Solution 2 Rahul solanki
Solution 3 marc_s

Related Questions