Hi i need to pull model numbers only from a cell there are 800+ of them. The model number starts with a PY-****. Thank you.
please please try copy&paste … it isn’t so difficult !
1 Like
Test with: =REGEX(REGEX(A1;".*PY-";"PY\-");"_.*";"")
If this don’t work, share a text sample, not a screenshot. Thanks.
1 Like
Where do i learn how to create those formulas?
Functions by Category.
You can press Ctrl+F2 to open the Function Wizard.
https://documentation.libreoffice.org/en/english-documentation/
1 Like
single shot:
=REGEX(A1;".*/(PY-\d+).+$";"$1" )
3 Likes