Adding in Excel new function extract() everywhere()

New Contributor

Hi,
To improve Excel experience I suggest for #excel team
to:
0) shortcut to have list of different excel tables in workbook like fn+f3
1) Add the function or the option everywhere(), or first(), last(), second() to replace wildcard * in Xlookup and XMatch without an extra argument 2 for wildcard, [Xlookup("*word*",...], [Xlookup("*word",...], [Xlookup("word*",...] --> [Xlookup(everywhere(word),...], [Xlookup(first(word),...],[Xlookup(last(word),...]

2)To find the word before/after "-" for example in a text, you can add before() function and after() function like that:

a) before(delimiter, text) to find the substring before the first occurrence of "-"

b) after(delimiter, text) to find the substring after the last occurrence of "-"

c) between(text, first delimiter1, delimiter2) to extract the substring between first delimiter and second delimiter

d) extract() function to all pervious tasks with different arguments,
1) extract(text, before, delimiter1, [delimiter2])
2) extract(text, after, delimiter1, [delimiter2])
3) extract(text, between, delimiter1, [delimiter2])

 

Best Regards,
Mourad

0 Replies