I’m trying to select a string in Libre Office Calc, with this function and is working
=INDEX(AI2:AL2,MATCH("[A-Z0-9]+" ,AI2:AL2,0))
However, when I put a sequence of string (sentence), it gives me an #N/A. when I checked the problem the function rejected the spaces between the words.
Is there is a way to deal with space and lets the MATCH function deal with a full string?
Thank you