Hi there.
I currently got a formula named =LEFT(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&1234567890))-2) with the function to exclude anything appearing after a piece of text contains a space and a number, like this:
Starting values:
Test 1
Testtest 123
Test test 123 321
Test test 123, test test
With current formula, it turns into:
Test
Testtest
Test test
Test test
... Now what I need, is a formula that does the opposite: finding the first appearing number and exclude anything BEFORE the first appearing number, like this:
Starting values:
Test 1
Testtest 123
Test test 123 321
Test test 123, test test
What it needs to turn into:
1
123
123 321
123, test test
Can anyone help me out? Thanks in advance!
Bookmarks